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

List the ways to get the count of records in a table?

853

What type of database is sql?

979

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

972

What are the popular database management systems in the it industry?

929

What is a recursive stored procedure?

1098

Which data dictionary views have the information on the triggers that are available in the database?

1182

How do rank () and dense_rank () differ?

977

What is pessimistic concurrency control? : Transact sql

1025

What is normalisation and its types?

957

Why is sharding used?

941

Describe types of sql statements?

994

What is left join in sql?

1006

What is record type in pl sql?

941

How do I filter in sql profiler?

949

What is the difference between alter trigger and drop trigger statements?

1044