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

Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you join a table to itself?

716


Explain the working of primary key?

839


Can I join the same table twice?

747


Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

662


When is the explicit cursor used ?

766


What is crud sql?

716


Can unique keys be null?

665


What is a primary key called that is made up of more than one field?

1035


What is the maximum size of sqlite database?

731


How do I run pl sql in sql developer?

863


Can a varchar be a primary key?

701


How do you create a db file?

716


Why truncate is faster than delete?

800


What is the trigger in sql?

701


What is %type in sql?

696