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

How to execute a stored procedure?

1092

what is datawarehouse? : Sql dba

1018

Which version of sql do I have?

1057

How to call a javascript function from pl sql?

1143

What is where clause in sql?

1041

What is record data type?

918

What are different types of statements supported by sql?

1165

What is the limitation on the block size of pl/sql?

987

What is sqlcommand?

1032

What is normalization in sql?

1016

how can we destroy the cookie? : Sql dba

1012

What are sql built in functions?

937

What are the differences between in and exists clause?

1111

Can I join the same table twice?

1046

Why we use joins in sql?

985