select 1,2,3,4,5,6,7,8,9,10 from dual;

i want to display 1 to 10 numbers using one select statement.

Question Posted / rashmi raju

Answer Posted / rashmi raju

Is This Answer Correct ?

3 Yes

20 No

Please Help Members By Posting Answers For Below Questions

what is a control file ? : Sql dba

1002

What is the file extension for sql database?

965

How is data stored on a disk?

988

What is trigger in sql?

1050

What packages are available to pl/sql developers?

1012

Can a select statement fire a trigger?

1119

Write the alter statement to enable all the triggers on the t.students table.

1092

What are sql triggers used for?

974

what is bdb (berkeleydb)? : Sql dba

994

How to pipe multiline string to isql?

981

What is a Mapplet?

1083

How do you rank data in sql?

960

What is cascade in sql?

933

explain the difference between delete , truncate and drop commands? : Sql dba

1047

What is a nested table in word?

934