How many rows will return from dual table?

Answer Posted / amit kumar shrivastava

Oracle Provide DUAL table with only one row and one column.
So it will always return one row.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is delete faster than truncate?

749


What are aggregate functions in sql?

839


Does sql support programming?

767


how to concatenate two character strings? : Sql dba

743


what are different types of keys in sql?

767






what is a database lock ? : Sql dba

780


how does a local variable is defined using t-sql? : Transact sql

728


What are the advantages of pl sql over sql?

733


What are different clauses used in sql?

813


What is the syntax and use of the coalesce function?

810


What is the difference between delete, truncate and drop command?

749


What is sql analyzer?

759


What is group function in sql?

749


Why is stored procedure faster than query?

699


What is java sql connection?

691