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

difference between anonymous blocks and sub-programs.

1188

What do you understand by pl/sql packages?

1107

how to delete an existing column in a table? : Sql dba

1063

What is the difference between functions, procedures, and packages in pl/sql?

1096

Is grant a ddl statement?

945

Can we rollback after truncate?

1073

How can we implement rollback or commit statement in a trigger?

1085

explain primary keys and auto increment fields in mysql : sql dba

1017

What is the use of sqlerrd 3?

994

How to write html code in pl sql?

1161

What is where clause in sql?

1088

What is left join in postgresql?

1092

What are the indexing methods?

1099

How do you change a value in sql?

1068

How can check sql version from command line?

1138