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

What is server name sql?

575

What is an alias command?

567

How do you change a value in sql?

542

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1699

what are string data types? : Sql dba

500

Does sql full backup truncate logs?

522

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

638

What is the use of primary key?

530

What are different types of sql?

551

What is the purpose of my sql?

499

Explain polymorphism in pl/sql.

633

Is sql better than access?

534

What is union and union all keyword in sql and what are their differences?

568

what is data control language? : Sql dba

578

What is sql exception?

513