i want to display 1 to 10 numbers using one select statement.
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
what are aggregate and scalar functions? : Sql dba
what is csv? : Sql dba
how to enter characters as hex numbers? : Sql dba
How to know the last executed procedure?
What do you mean by “trigger” in sql?
What is bind reference and how can it be created?
What is the largest value that can be stored in a byte data field?
What is meant by <> in sql?
What is the difference between in and between in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Explain autonomous transaction.
How does an execution block start and end in pl sql?
How is pl sql different from sql?
Why do we need a foreign key?
What is break?