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 a recursive join sql?

1069

What is sql character function?

1078

explain mysql aggregate functions. : Sql dba

986

What are triggers in sql?

1020

How to avoid using cursors?

1120

What is minus?

988

What is data control language (dcl)?

1137

How many sql core licenses do I need?

944

What is a sql trace file?

1026

What does data normalization mean?

961

How to pipe multiline string to isql?

1005

What is indexes?

1056

Why we use sql profiler?

956

What is oracle pl sql developer?

980

What is replication id?

935