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 I copy a table in sql?

945

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1036

What is difference between stored function and application function?

1130

How do I create a sql database?

961

What is materialized view in sql?

883

what is the difference between char and varchar data types? : Sql dba

1021

How do you go back in sql?

952

What are the operators used in select statements?

1015

how to write date and time literals? : Sql dba

927

Describe types of sql statements?

1016

Is primary key is clustered index?

957

What is the difference between jpql and sql?

1043

Will truncate release space?

904

Why stored procedures are faster than query?

984

Are pl sql variables case sensitive?

1011