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 difference between hql and sql?

513

What is the largest value that can be stored in a byte data field?

521

What is materialized view in sql?

469

Does truncate free space?

520

Which join is default?

525

What is a clob in sql?

569

Can we join two tables without common column?

516

what is the syntax used for partition in tsql? : Transact sql

542

what is the difference between truncate and delete statement? : Transact sql

552

What does the base_object_type column shows in the user.triggers data dictionary view?

578

What is pl sql block structure?

545

How many sql statements are used? Define them.

577

What is keys and its types?

547

Why we use pl sql?

531

What are the types of join in sql?

520