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 write an index?

524

What is sql trigger example?

536

What is sql indexing?

552

How can you get sql*loader to commit only at the end of the load file? : aql loader

552

how to delete an existing column in a table? : Sql dba

550

How we can update the view?

599

What schema means?

523

What is auto increment in sql?

583

What are database links used for?

591

What is the current version of postgresql?

552

how to convert character strings to numeric values? : Sql dba

572

How many sql commands are there?

673

What is output spooling in sql*plus?

549

Can we rename a column in the output of sql query?

539

What is composite data type in pl sql?

554