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 data types in pl sql?
What are the types of variable use in pl sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is the use of index in sql?
What are the uses of sysdate and user keywords?
what are the 'mysql' command line options? : Sql dba
What is a sql statement?
What is index example?
What are triggers and its types?
Why is stored procedure faster than query?
How do you create an update query?
What is sql catalog?
Can we use insert statement in function?
What is the maximum number of triggers, you can apply on a single table?
What is sql*loader?