select 1||chr(10)||2||chr(10)||3||chr(10)||4||chr(10) ||5||chr(10)||6||chr

i want to display 1 to 10 numbers using one select statement.

Question Posted / hemant

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

Please Help Members By Posting Answers For Below Questions

What is the process of debugging?

557

Which is faster view or stored procedure?

507

What is sql and db2?

538

What is the syntax to add a record to a table?

578

What sql database should I use?

553

what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba

554

What are the different tcl commands in sql?

624

explain advantages of myisam over innodb? : Sql dba

609

What is the reports view in oracle sql developer?

545

What is a full join sql?

596

What is the best partition size for windows 10?

487

What are sql objects?

546

What is the purpose of the primary key?

568

What is using in sql?

570

How to add a column ‘salary’ to a table employee_details?

595