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

Is postgresql a server?

1113

How do I partition a table in sql?

1208

what are the different index configurations a table can have? : Sql dba

1042

How will you distinguish a global variable with a local variable in pl/sql?

1202

Explain autonomous transaction.

1221

What is snowflake sql?

1128

Is ms sql traffic encrypted?

962

Can primary key be changed?

953

What is a left inner join?

1069

Why do we use procedures?

1007

How do you declare a variable in pl sql?

1071

How to select random rows from a table?

1135

Inline the values in PL/SQL, what does it mean.?

1275

How to use distinct and count in sql query? Explain

1083

What is pl sql record in oracle?

1089