select rownum from dual connect by rownum <=10

how to produce numbers from 1 to 10 using dual table

Question Posted / arunkumar t

Answer Posted / arunkumar t

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a tns file?

997

How to define a data field as not null?

1109

State any two functions of oracle?

1046

What is a system tablespace?

1080

What is SQL access advisor in Oracle?

1192

Which is better Oracle or MS SQL? Why?

6388

Why should I use oracle database?

992

What is an oracle data file?

1103

How to save query output to a local file?

1027

How to convert numbers to characters in oracle?

1030

What is system tablespace?

1098

What is oracle used for?

1026

What is an Oracle Instance?

1123

What is a nested table?

1062

How to Truncate Table in Oracle

1156