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 does dml mean?

549

What is the difference between local and global temporary table?

554

List the various privileges that a user can grant to another user?

587

Is mariadb a nosql database?

542

What do you think about pl/sql?

535

What is cross join example?

556

What are the types of join in sql?

521

Is sql an operating system?

546

What is sap sql?

540

What is difference between my sql and sql?

532

Can I call a procedure inside a function?

556

how to use in conditions? : Sql dba

514

Why is a trigger used?

531

How can a function retun more than one value in oracle with proper example?

590

Can a trigger call a stored procedure?

541