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 a crud api?

948

Can sql function call stored procedure?

1013

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

959

Is trigger a stored procedure?

929

Can we use delete in merge statement?

1033

What are the constraints available in sql?

1044

what is a relationship and what are they? : Sql dba

1093

What is autocommit sql?

978

What are the different types of database management systems?

995

What is aggregate function in sql?

1030

Can a select statement fire a trigger?

1152

What is the difference between sql, mysql and sql server?

1090

Why is a trigger used?

933

Why use triggers in sql?

948

What is column?

981