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 |
How to use distinct and count in sql query? Explain
How do you drop a trigger?
How do I run a sql script?
What are analytical functions in sql?
Is mariadb nosql?
Is sql easier than java?
What is a sql statement?
what are the different type of normalization? : Sql dba
What is difference between hql and sql?
What is union and union all keyword in sql?
What will you get by the cursor attribute sql%notfound?
What are character functions in sql?