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 would you get the current date in mysql? : Sql dba
table - new_no old_no 2345 1234 3456 2345 5678 4567 output sud be -new_no 1234 2345 3456 4567 5678
In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop
Do ddl statements need commit?
what is the use of double ampersand (&&) in sql queries?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Does sap use sql?
how to load data files into tables with 'mysqlimport'? : Sql dba
what is global variable in pl/sql
Types of joins?
What is the purpose of a secondary key?
What are the different sql languages?