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

What is a temp table?

562


what is a stored procedure? : Sql dba

548


What are the events on which a database trigger can be based?

589


Show the two pl/sql cursor exceptions.

609


What is a sql trace file?

545






Who is the owner of mysql database?

549


Is primary key an index?

531


What is the difference between having and a where in sql?

570


Explain the difference between 'between' & 'and' operators in sql

524


What are the built in functions of sql?

555


What does trigger mean in slang?

521


how to check myisam tables for errors? : Sql dba

595


how to start mysql server? : Sql dba

609


How to handle bulk data?

889


What is integrity in sql?

552