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

How to rename a table?

953

How can you load microsoft excel data into oracle? : aql loader

1127

What is oracle and pl sql?

1074

Does sql require a server?

939

What is cursor in pl sql?

1049

what is the difference between a web-garden and a web-farm? : Sql dba

1009

What are variables in pl sql?

1090

which operator is used in query for pattern matching? : Sql dba

946

Describe sql comments?

959

What are the ways on commenting in a pl/sql code?

1046

What is a left inner join?

942

What is attribute indicator in pl sql?

958

List and explain the different types of join clauses supported in ansi-standard sql?

1299

What is difference between hql and sql?

988

How do you respond to dementia behavior?

921