Sign Up Login


  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

Can we use out parameter in function?

4 Answers   Infosys,

What is the difference between truncate and drop statements?

0 Answers  

What are different types of keys?

0 Answers  

how to create a table index in mysql? : Sql dba

0 Answers  

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  




Explain locks? : Transact sql

0 Answers  

Is t sql a programming language?

0 Answers  

How do I edit a stored procedure?

0 Answers  

Is sql better than excel?

0 Answers  

Why we use triggers in mysql?

0 Answers  

What is the difference between sql and isql*plus?

0 Answers  

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories