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 |
Is json a nosql?
What is sql resultset?
How packaged procedures and functions are called from the following?
what is meant by DML?
What is flag in sql?
What is the use of pl/sql table?
how to create a new table in mysql? : Sql dba
How do you remove duplicates without using distinct in sql?
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
Define sql delete statement.
What is use of package in pl sql?
What is $$ in sql?