SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10) WHERE n&

how to produce numbers from 1 to 10 using dual table

Question Posted / nihar ranjan nath

Answer Posted / nihar ranjan nath

SELECT n FROM (SELECT ROWNUM n FROM DUAL CONNECT BY LEVEL<=10)
WHERE n<=1;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is an oracle table?

556

What is execute immediate in oracle?

549

State the various uses of dbcc command?

549

What are a collation and state the different types of collation sensitivity?

550

Explain the difference between a procedure and a function?

561

How to select all columns of all rows from a table in oracle?

590

What is the implicit cursor in oracle?

570

What is oracle latest version?

583

How to start an oracle instance?

574

What is backup in Oracle?

571

Can we write insert statement in function in oracle?

534

What are the different types of partitions in oracle?

496

What is a database table in oracle?

572

Explain view?

577

State the difference between a primary key and foreign key?

518