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

Why should I use postgresql?

1015

What are the limitations of sql express?

1069

Explain normalization and what are the advantages of it?

953

What are properties of the transaction?

998

What is query syntax?

969

What are the most important characteristics of pl/sql?

1157

What are sql built in functions?

936

How to make a copy values from one column to another in sql?

1037

what is 'mysqld'? : Sql dba

969

What is the difference between microsoft sql and mysql?

960

What is the difference between partition and index?

992

how to load data files into tables with 'mysqlimport'? : Sql dba

1092

What is trigger types of trigger?

1069

What does t sql mean?

945

What do you mean by query optimization?

1002