select level from dual connect by level<=10

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

Question Posted / manoj

Answer Posted / manoj

Is This Answer Correct ?

113 Yes

18 No

Please Help Members By Posting Answers For Below Questions

What is PL/SQL Records?

1179

What is the mutating table and constraining table?

1023

what is self-join? : Sql dba

1147

What is on delete restrict?

998

How to run sql statements through the web interface?

1030

Is sqlite thread safe?

1040

What does inner join mean?

1152

What are the datatypes available in pl/sql ?

1094

What is pl sql block structure?

1030

Is microsoft sql free?

1093

What is sqlservr exe?

973

What are the different types of constraints?

1166

Does normalization improve performance?

1028

Which sql statement is used to return only different values?

995

How many sql statements are used? Define them.

1030