i want to display 1 to 10 numbers using one select statement.
Answers were Sorted based on User's Feedback
Answer / gangadhar
SQL> select *
2 from xmltable('for $i in 1 to 10 return $i');
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / hemant
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
/
Is This Answer Correct ? | 6 Yes | 12 No |
How to start the command-line sql*plus?
what is 'mysqlimport'? : Sql dba
how to rename an existing table in mysql? : Sql dba
How many LONG columns are allowed in a table?
Is sql a scripting language?
Which is better trigger or stored procedure?
What is sql profiler in oracle?
Why are aggregate functions called so?
what is the difference between binary_integer and pls_integer
what is the syntax used for partition in tsql? : Transact sql
What is field delimiter?
How do you handle exceptions. Give the syntax for it?