select level from dual connect by level <=10;

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

Question Posted / pramod kumar behera

18 Answers
46976 Views
HCL, Nyros, Oracle, I also Faced
E-Mail Answers

Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is meant by truncate in sql?

1004

What is sqlerrm?

882

What is the meaning of disabling a trigger?

1111

Explain what is sql*plus?

1085

What is sql engine in oracle?

927

what is the difference between delete and truncate statement in sql? : Sql dba

1127

What is sql basics?

991

What's the procedure?

865

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537

What is dba in sql? : SQL DBA

997

What is difference between db2 and sql?

938

how to use in conditions? : Sql dba

958

What's the difference between a primary key and a clustered index?

946

What is sql table?

903

what is the difference between truncate and drop statements? : Sql dba

1033