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 include character strings in sql statements? : Sql dba

1141

What is nvl?

1116

What are character functions?

1141

Can we use update in sql function?

1116

Is sql a case sensitive language?

1010

What is structural independence and why is it important?

1074

What is an inner join sql?

1099

Explain the uses of control file.

1101

What is schema in sql example?

1282

What is difference between procedure and trigger?

1022

How do you truncate?

956

What are the parameter modes supported by pl/sql?

1154

what is the use of set statement in tsql? : Transact sql

1063

What is the purpose of primary key?

1073

What is inner join in sql?

1139