select rownum from user_objects where rownum <= 10 order by rownum ASC

i want to display 1 to 10 numbers using one select statement.

Question Posted / srikanth

Answer Posted / srikanth

select rownum from user_objects where rownum <= 10 order by
rownum ASC

Is This Answer Correct ?

12 Yes

9 No

Please Help Members By Posting Answers For Below Questions

How do you pronounce sql?

1020

How can we optimize a sql query?

1053

Can procedure in package be overloaded?

1089

What is data types in sql?

1011

Is it possible to update views?

963

What is interval partition?

1061

Can we use threading in pl/sql?

1043

what is 'mysqlimport'? : Sql dba

1060

what is the use of double ampersand (&&) in sql queries?

1178

Can we use pl sql in mysql?

1019

What is dbo in sql?

976

Can a table contain multiple primary key’s?

1104

what is query cache in mysql? : Sql dba

1042

Can one improve the performance of sql*loader? : aql loader

1052

Can we use loop in sql?

972