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 to include comments in sql statements? : Sql dba

1 Answers  

What does the sign mean in sql?

1 Answers  

What does “select count(1) from tab” result?

10 Answers   IBM,

How many commands are in sql?

1 Answers  

What is use of trigger?

1 Answers  

What are the 3 modes of parameter?

1 Answers  

What is a primary key, and how is it different from a unique key?

3 Answers  

Tell me what a package consists of.

3 Answers  

Can we enter data in a table in design view?

1 Answers  

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

1 Answers  

in materialized view the structure will create immediately or not?

2 Answers   iFlex,

what is self join and how it works??

2 Answers   Infosys,

For more SQL PLSQL Interview Questions Click Here
Categories