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 to include numeric values in sql statements? : Sql dba

1149

How do you delete a table?

1124

What is auto increment feature in sql?

1174

How do I partition in sql?

1023

What is sql and also describe types of sql statements?

1114

How many types of functions are there in sql?

1008

Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1224

Does varchar need length?

1049

what is query cache in mysql? : Sql dba

1081

What is difference between table and view?

1137

What is cursor and its types?

1152

What sql database should I use?

1194

What is difference between joins and union?

1195

Why is partition used in sql?

1183

Can dml statements be used in pl/sql?

1125