SELECT ROWNUM, LEVEL FROM DUAL CONNECT BY LEVEL

How many rows will return from dual table?

Question Posted / sen

Answer Posted / sen

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

Is This Answer Correct ?

9 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain what is rdbms?

1026

What is the clause we need to add in function body to return variable?

1009

Explain what is dbms?

1051

Which table is left in left join?

1009

What is the use of nvl function?

1190

What are local and global Indexes and where they are useful.

1437

What are the two characteristics of a primary key?

967

What are the properties of a transaction?

1128

how to enter binary numbers in sql statements? : Sql dba

968

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1138

How can you get sql*loader to commit only at the end of the load file? : aql loader

1008

What do you know by pl/sql cursors?

1098

What is the difference between delete, truncate and drop command?

1137

Differentiate pl/sql and sql?

1062

What are the features of pl sql?

1061