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 normalization means?

1017

how to drop an existing table in mysql? : Sql dba

1092

What is trigger in sql?

1156

What is the need of merge statement?

1092

Define overloaded procedure?

1132

What is the size of partition table?

1093

How do you delete data from a table?

1104

What are the different tcl commands in sql?

1232

how can we know the number of days between two given dates using mysql? : Sql dba

1089

Which function is used to return remainder in a division operator in sql?

1203

The select into statement is most often used to create backup copies of tables or for archiving records?

1120

What is row_number () in sql?

1025

Explain the difference between triggers and constraints?

1025

what is the use of set statement in tsql? : Transact sql

1063

who introduced sql?

1074