select rownum from user_objects where rownum <= 10

i want to display 1 to 10 numbers using one select statement.

Question Posted / mkumar.it

Answer Posted / mkumar.it

Is This Answer Correct ?

71 Yes

20 No

Please Help Members By Posting Answers For Below Questions

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1063

What is rownum in sql?

1043

What is record data type?

912

What is trigger and stored procedure in sql?

1031

What is right join sql?

964

Are views faster than queries?

990

explain the delete statements in sql

1054

What are stored procedures in mysql?

1017

What is self-join and what is the requirement of self-join?

1151

Explain dml and ddl?

989

Why is stored procedure faster than query?

960

how to concatenate two character strings? : Sql dba

1099

What are secondary keys?

971

Can we write dml inside a function in sql server?

946

Is full outer join same as cross join?

969