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

what is a table in a database ? : Sql dba

1028

What kind of join is join?

956

What is oracle sql called?

915

Explain the difference between 'between' & 'and' operators in sql

991

What is the process of debugging?

1060

What is an invalid partition table?

1021

How do I restart sql?

955

What is set transaction?

1027

How do I find duplicates in the same column?

1075

Why do we need view in sql?

976

What is the difference between the sql*loader and import utilities? : aql loader

1026

What is nosql vs sql?

1171

Can delete statement be rollbacked?

979

How do I delete a trigger?

957

How do I view a table in sql?

998