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 view an execution plan in sql?

711

Does sap use sql?

718

How to move files from one directory to another in pl sql?

857

What is implicit cursor in pl sql?

739

Mention what does plv msg allows you to do?

856

explain the options of myisamchk to improve the performance of a table. : Sql dba

721

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

821

How many sql statements are used? Define them.

776

What is rollback?

787

How do you delete a table?

765

What type of join is sql join?

719

Can we create index on primary key?

717

How do you modify a trigger?

695

How can I see all tables in sql?

727

Explain the working of primary key?

839