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

what are the types of join and explain each? : Sql dba

1030

How do I tune a sql query?

967

What is replication id?

929

What does the sign mean in sql?

982

What is the usage of nvl function?

1030

How do I view output in sql developer?

1071

What is the difference between distinct and unique in sql?

937

Can we insert in sql function?

1074

What is a Mapplet?

1116

Explain polymorphism in pl/sql.

1110

How to assign sql query results to pl sql variables?

1066

Can we call a function containing dml statements in a select query?

966

Explain the working of foreign key?

1056

What mean sql?

1000

What is a trigger word?

1015