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 a parameter query?
What is a behavioral trigger?
Explain UNION,MINUS,UNION ALL, INTERSECT?
What is a unique key?
How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.
Explain the difference between triggers and constraints?
how to get enames with comma seperated values by deptwise on emp table?
what is mean by forward declaration and where we'll use it.
I have one table,in that table (1)i have java1.1 version books are 2 and java1.5 version books are 4. (2).Net2.0 books are 3, .Net3.5 books are 2 (3)ABC1.6 books are 4, ABC2.0 books are 3. Now i want output is like Book Count Java 6 .Net 5 ABC 7 For this i need sql query, please help me if anyone how to get this result. Thanks, Seenu
Can delete statement be rollbacked?
Which query operators in sql is used for pattern matching?
what is myisam? : Sql dba