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

What are the different dml commands in sql?

1166

How is a PL/SQL code compiled?

1220

What is the use of index in hive?

1000

which tcp/ip port does sql server run on? : Sql dba

1018

Why do we go for stored procedures?

1047

Where is sql database stored?

977

What is the syntax and use of the coalesce function?

1160

What is dynamic query?

964

Differentiate between pl/sql and sql?

1143

what is a constraint? : Sql dba

1144

Can we use having without group by in sql?

979

What does sign mean sql?

1091

what is sql? : Sql dba

1019

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

948

Where the sql database files are stored?

1009