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

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

More SQL PLSQL Interview Questions

What is sql*loader and what is it used for? : aql loader

0 Answers  


Which language is used in sql?

0 Answers  


How to fetch alternate records from a table?

0 Answers  


What is rtm in testing?

0 Answers  


how to findout the 100th maximum salary

28 Answers   Amdocs,






how to create object in plsql

3 Answers   Microsoft,


How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,


What is a primary key? Explain

0 Answers  


What is the purpose of cursors in pl/sql?

0 Answers  


What is the purpose of normalization?

0 Answers  


What is rownum and rowid?

0 Answers  


use of IN/ANY/ALL

5 Answers   Ramco,


Categories