i want to display 1 to 10 numbers using one select statement.
Answers were Sorted based on User's Feedback
Answer / mkumar.it
select rownum from user_objects where rownum <= 10
Is This Answer Correct ? | 71 Yes | 20 No |
Answer / pramod kumar behera
select rownum from dual connect by level <=10;
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / pramod kumar behera
select level from dual connect by level <=10;
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / srikanth
select rownum from user_objects where rownum <= 10 order by
rownum ASC
Is This Answer Correct ? | 12 Yes | 9 No |
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 |
Answer / nagesh
SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;
Is This Answer Correct ? | 6 Yes | 3 No |
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 |
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 |
What is sql*loader and what is it used for? : aql loader
Which language is used in sql?
How to fetch alternate records from a table?
What is rtm in testing?
how to findout the 100th maximum salary
how to create object in plsql
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?
What is a primary key? Explain
What is the purpose of cursors in pl/sql?
What is the purpose of normalization?
What is rownum and rowid?
use of IN/ANY/ALL