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 does cursor do in sql?

968

What is memory optimized table?

984

Explain the the update statement in sql?

986

How to load data with sql*loader?

993

Explain the commit statement.

1101

What is the difference between cluster and non-cluster index?

1044

How do I save a stored procedure?

944

what is primary key? : Sql dba

948

What is break?

1139

Which command is used to call a stored procedure?

949

How to run pl sql program in mysql?

938

Can you join a table to itself?

1029

What is record data type?

857

What are tuples in sql?

1058

What is the difference between Union and Union all. Which is faster.

1339