select level 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 ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Write a sql query to convert all character to uppercase after hypen.

1388

What is pivot query?

1022

What is scalar function?

1008

Explain the steps needed to create the scheduled job?

978

What are the basic sql commands?

1047

What are the various levels of constraints?

1070

Difference between table function and pipelined function?

975

Can we insert data into materialized view?

904

What is pl sql code?

1002

What is pl sql in oracle?

1002

What is the process of debugging?

1017

What are tables and fields?

984

What is the difference between sum and count in sql?

948

Can sql developer connect to db2?

997

what is the difference between a web-garden and a web-farm? : Sql dba

1023