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 are the nonstandard string types? : Sql dba

0 Answers  

When can we use the where clause and the having clause?

0 Answers  

What are the two types of periodical indexes?

0 Answers  

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

What is Overloading of procedures ?

4 Answers   Amdocs,




What are local and global variables and their differences?

0 Answers  

Is merge a dml statement?

0 Answers  

What is the difference between having clause and where clause?

0 Answers  

What is a sql driver?

0 Answers  

What is a record in pl/sql?

0 Answers  

What is a unique key and primary key and foreign key?

0 Answers  

What is the best strategy to use COMMIT in a pl/sql loop?

3 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories