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 #table in sql?

994

What are the types of optimization?

886

What is bulk compiling in pl/sql.?

1058

What are the constraints available in sql?

994

What are joins in sql?

955

How to make a copy values from one column to another in sql?

978

What is function and procedure?

980

What is difference between hql and native sql?

1089

How to set up sql*plus output format in oracle?

971

Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?

955

explain what is mysql? : Sql dba

1030

Explain the the update statement in sql?

986

How does postgresql compare to "nosql"?

980

Why primary key is required?

935

Define union, minus, union all, intersect ?

949