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 PL/SQL Records?

1252

What is a boolean in sql?

1025

Explain what is rdbms?

1085

Difference between truncate, delete and drop commands?

1141

What is bind variable in pl sql?

1102

Can we create foreign key without primary key?

1036

What does seeding a database mean?

1014

What are the different operators available in sql?

1057

What is serial sql?

1038

How do I count duplicates in sql?

1175

What are sql ddl commands?

1136

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1300

How exception is different from error?

1064

What is an implicit commit?

1100

How can you save or place your msg in a table?

1036