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
46973 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 / manoj

select level from dual connect by level<=10

Is This Answer Correct ?

113 Yes

18 No

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

Answer / mkumar.it

select rownum from user_objects where rownum <= 10

Is This Answer Correct ?

71 Yes

20 No

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

Answer / pramod kumar behera

select rownum from dual connect by level <=10;

Is This Answer Correct ?

6 Yes

0 No

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

Answer / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?

7 Yes

1 No

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

Answer / srikanth

select rownum from user_objects where rownum <= 10 order by
rownum ASC

Is This Answer Correct ?

12 Yes

9 No

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

Answer / raghuramu

select rownum from emp
where rownum<=10;

Is This Answer Correct ?

13 Yes

10 No

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

Answer / kriti sinha

For in 10 rows in a single column
select level from dual connect by level<=10

for 10 numbers in a single column
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;

For 10 rows in 10 columns
select 1,2,3,4,5,6,7,8,9,10 from dual;

Is This Answer Correct ?

3 Yes

0 No

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

Answer / nagesh

SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;

Is This Answer Correct ?

6 Yes

3 No

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

Answer / srinivas

select rownum rn from (select 1 from dual group by
cube(1,2,3,4,5)) where rownum <=10

Is This Answer Correct ?

1 Yes

0 No

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

Answer / sumit

declare
abc varchar2(500) ;
begin
select 1||chr(0)||2||chr(0)||3 ..... into
abc from dual;
dbms_output.put_line(abc);
end;

cannot use chr(10) to take columns in sql.

way is to use rownum,row_number or any psuedo column like
sequence

Is This Answer Correct ?

1 Yes

0 No

Post New Answer