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 can we know the count/number of elements of an array? : Sql dba

1057

What are the different operators available in sql?

997

What is a sql*loader control file?

1253

Can you have more than one key in a database?

931

What are views in sql?

975

How do you concatenate in sql?

1023

What are types of exception?

916

What is the purpose of primary key?

1012

How do you optimize a stored procedure in sql?

943

what is the bond code in materialized view?

2999

Is sql database free?

965

What are different types of functions in sql?

999

What does a pl/sql package consist of?

971

What are character functions?

1079

How does postgresql compare to oracle/db2/ms sql server/informix?

1029