i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 44882 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
Why do we need cursors in pl sql?
What is prepared statement in sql?
Why we use pl sql?
What is the use of primary key?
What is join view in sql?
Does group by remove duplicates?
how to get a list of all tables in a database? : Sql dba
what is try_catch block in procedure
How many parts of a pl sql block are optional?
Is pl sql useful?
Where can I learn sql for free?
Why is nosql good?
What is difference between stored procedures and application procedures?
Explain the the update statement in sql?
