1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

How many rows will return from dual table?

Question Posted / godi

Answers were Sorted based on User's Feedback



How many rows will return from dual table?..

Answer / godi

only one row one coloumn

Is This Answer Correct ?    31 Yes 3 No

How many rows will return from dual table?..

Answer / sen

SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;

Is This Answer Correct ?    9 Yes 2 No

How many rows will return from dual table?..

Answer / manoj

Any single row manipulation will work with dual. So only one
out put will work.

Is This Answer Correct ?    6 Yes 1 No

How many rows will return from dual table?..

Answer / 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

More SQL PLSQL Interview Questions

What is primary key and foreign key with example?

0 Answers  

Explain spool.

0 Answers  

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

0 Answers   IBM,

Define select, insert, create, delete, update, drop keywords

0 Answers  

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

0 Answers  




What is auto increment in sql?

0 Answers  

How do you change a value in sql?

0 Answers  

what are the differences between char and nchar? : Sql dba

0 Answers  

Do we need to rebuild index after truncate?

0 Answers  

How to write pl sql program in mysql command prompt?

0 Answers  

What is mutating error?

0 Answers  

How many primary keys can a table have?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories