SELECT LEVEL FROM DUAL CONNECT BY LEVEL<=9;

i want to display 1 to 10 numbers using one select statement.

Question Posted / subrat

Answer Posted / subrat

SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL<=9;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is cross join sql?

917

What is minus?

988

what is csv? : Sql dba

995

Is subquery faster than join?

1013

What are the methods of filing?

935

What is foreign key and example?

936

How can we make an if statement within a select statement?

1013

what is bcp? When does it used? : Sql dba

988

What is procedure in pl sql?

1041

What is tuple in sql?

1075

What is difference between stored function and application function?

1199

What is a join?

1068

What is the use of function "module procedure" in pl/sql?

1196

What is rename in sql?

972

how many columns can be used for creating index? : Sql dba

946