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 if we write return in procedure?

1352

discuss about myisam key cache. : Sql dba

985

What packages are available to pl/sql developers?

1000

what is 'mysqld'? : Sql dba

926

What is sp_helptext?

1016

what are the difference between clustered and a non-clustered index? : Sql dba

988

What is difference between rank () row_number () and dense_rank () in sql?

1059

Can you inner join the same table?

946

What is pl sql code?

1002

Is pl sql still used?

935

What is compound trigger?

974

how to drop an existing index in mysql? : Sql dba

1029

What is schema in sql?

892

What is row_number () in sql?

942

What is the difference between sum and count in sql?

948