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

How many sql commands are there?

0 Answers  

What is the main reason behind using an index?

0 Answers  

what is 'mysqlshow'? : Sql dba

0 Answers  

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

1 Answers   CGI,

How do I create an index in word?

0 Answers  




how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  

four procedures is are there should i write their in a package

2 Answers  

Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?

5 Answers   HSBC,

How do I count records in sql?

0 Answers  

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

What is data types in sql?

0 Answers  

Explain the uses of control file.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories