i want to display 1 to 10 numbers using one select statement.
Answer Posted / 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 |
Post New Answer View All Answers
How to move files from one directory to another in pl sql?
Explain the difference in execution of triggers and stored procedures?
What is the difference between a query and a report?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the use of primary key?
When is the update_statistics command used?
how would concatenate strings in mysql? : Sql dba
What is a field in a database?
What is a null value?
Which is the correct statement about truncate and delete?
what are the type of locks ? : Sql dba
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Which join is like an inner join?
What is lookup table in sql?
Which table is left in join?