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

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / charykkr

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

Answers were Sorted based on User's Feedback

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

Answer / subrat

SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL<=9;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / gangadhar

SQL> select *
2 from xmltable('for $i in 1 to 10 return $i');

Is This Answer Correct ?

0 Yes

0 No

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

Answer / hemant

select 1||chr(10)||2||chr(10)||3||chr(10)||4||chr(10)
||5||chr(10)||6||chr(10)||7||chr(10)||8||chr(10)||9||chr(10)
||10 from dual
/

Is This Answer Correct ?

6 Yes

12 No

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

Answer / pushkar

use sequence. automatically increments.

Is This Answer Correct ?

10 Yes

27 No

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

Answer / rashmi raju

select 1,2,3,4,5,6,7,8,9,10 from dual;

Is This Answer Correct ?

3 Yes

20 No

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

Answer / ameer mujahid

select rownum from employees;

Is This Answer Correct ?

0 Yes

19 No

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

Answer / aditya

select 1,2,3,4,5,6,7,8,9,10

Is This Answer Correct ?

1 Yes

27 No

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

Answer / seshu

select in(1,10)
from dual;

Is This Answer Correct ?

15 Yes

71 No

Post New Answer