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 are the advantages of stored procedure?

946

What is the non-clustered index in sql?

1009

How can you fetch first 5 characters of the string?

946

What are the types of join in sql?

1027

How many postgresql users are there, worldwide?

992

Is sql database free?

924

Does pl sql work in mysql?

919

Where is all the data on the internet stored?

948

Is null operator in sql?

979

How many types of indexes are there in sql?

933

what are the disadvantages of mysql? : Sql dba

1075

What is a dynamic query?

971

What are the commands used in sql?

1013

what is try_catch block in procedure

1656

Can triggers stop a dml statement from executing on a table?

1024