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

4 Answers
10912 Views
Genpact, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pragma autonomous transaction in oracle?

1073

How to start a specific oracle instance?

1042

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2116

How to drop an existing view in oracle?

946

What is the exact use of Collections?

2143

if you ctreate table identity

2374

Explain self joins in oracle?

1023

Respected sir, Please send me technical questions related to oracle apps..

1813

How to display employee records who gets more salary than the average salary in the department?

1067

Can we connect to ORACLE db using Windows Authentication?

1257

What is a package in oracle?

1102

Difference between pre-select and pre-query

1115

Please explain joins in oracle?

1062

How to delete a column in an existing table in oracle?

1073

Explain the use of Merge statement in oracle 11g

1029