select in(1,10) from dual;

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

Question Posted / seshu

Answer Posted / seshu

select in(1,10)
from dual;

Is This Answer Correct ?

15 Yes

71 No

Please Help Members By Posting Answers For Below Questions

Mention what plvcmt and plvrb does in pl/sql?

1201

What are the commands used in sql?

1136

explain access control lists. : Sql dba

1050

Explain commit, rollback and savepoint.

1056

What do you understand by pl/sql packages?

1107

How can check sql version from command line?

1138

Does truncate free space?

1065

What is index example?

1048

what are integrity rules?

1092

What are all ddl commands?

1131

How is indexing done in search engines?

1023

What is %rowtype in pl sql?

1032

What does rownum mean in sql?

1091

What are the different types of functions in sql?

1099

How do I partition a table in sql?

1209