SELECT LEVEL FROM DUAL CONNECT BY LEVEL<=9;

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

Question Posted / subrat

Answer Posted / subrat

SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL<=9;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is coalesce faster than isnull?

715

Can we use two order by clause in query?

750

What is the difference between the implicit and explicit cursors?

765

what is the difference between nested subquery and correlated subquery?

769

What is dense_rank?

712

How do you identify a primary key?

834

What is mdb stand for?

762

Can pl sql procedure have a return statement?

748

How do I delete a trigger?

737

Is it mandatory for the primary key to be given a value when a new record is inserted?

946

How do I copy a table in sql?

709

Is natural join and inner join same?

678

What is the difference between sql and mysql?

790

What is group function in sql?

775

Does inner join remove duplicates?

710