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 do you mean by “trigger” in sql?

1019

Do we need to create index on primary key?

858

How do you identify a primary key?

1013

What is union?

1085

What is restrict in sql?

1035

Can variables be used in sql statements?

982

What is a record in a database?

994

how can we find the number of rows in a table using mysql? : Sql dba

1031

Can a key be both primary and foreign?

946

How can you know that statistics should be updated?

1025

What is group by in sql?

1027

What is the source code of a program?

1004

How do you optimize a stored procedure in sql?

896

what is a trigger in mysql? Define different types of trigger. : Sql dba

1012

Could you please provide oca (oracle 10g) dumps for my certification ?

5070