select rownum from dual connect by level <=10;

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

Question Posted / pramod kumar behera

Answer Posted / pramod kumar behera

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I edit a stored procedure?

998

What is varray in pl sql?

1081

How many types of cursors supported in pl/sql?

1196

What is coalesce sql?

1005

What are the differences between in and exists clause?

1115

What is the difference between cross join and natural join?

1029

What are the different type of joins in sql?

957

What do you mean by “trigger” in sql?

1086

Which is faster count (*) or count 1?

1038

How to place comments in pl/sql?

1169

Is sql a microsoft product?

954

how to convert character strings to dates? : Sql dba

1066

How to call shell script from pl sql procedure?

1285

What is rownum and rowid?

1039

What is sql rowcount?

1033