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 view explain with example?

993

Can we use pl sql in mysql?

1060

Why is normalization important?

1078

describe transaction-safe table types in mysql : sql dba

1052

Why stored procedure is faster than query?

1152

What are all types of user defined functions?

1131

How do you remove duplicates without using distinct in sql?

1016

Mention what plvcmt and plvrb does in pl/sql?

1197

What is compilation error in pl sql?

1023

How many types of triggers are there in pl sql?

1119

What is coalesce in sql?

1130

How do I run a pl sql procedure in sql developer?

1020

how to create a new table in mysql? : Sql dba

1030

Why do we need databases?

1085

Do foreign keys improve performance?

1068