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

What is database white box testing and black box testing?

1155

How does index help in query performance?

1085

what are the advantages of sql ? : Sql dba

1105

What is data modelling in sql?

1071

What is record variable?

1034

How do I view tables in sql developer?

1007

What does t sql mean?

1000

Does sql support programming?

1112

If a cursor is open, how can we find in a pl/sql block?

1212

How can we implement rollback or commit statement in a trigger?

1081

What is the purpose of the partition table?

1087

Is progress software supports to ( pl/sql )?

1093

What is date functions?

1088

What is java sql drivermanager?

1159

What is an invalid partition table?

1063