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 are packages in pl sql and also explain its advantages?

1044

What is database sql?

1058

What is recursive join in sql?

1032

What is record in pl sql?

1090

How to pipe multiline string to isql?

1010

What are the query optimization techniques?

941

What is sql basics?

1046

Why do we use subquery?

1018

what is oltp (online transaction processing)? : Sql dba

1083

Which table is left in join?

983

What is a mutating table and a constraining table?

1120

How can you fetch first 5 characters of the string?

1019

What is dialect in sql?

954

What does := mean in pl sql?

1047

What is offset and limit in sql?

1065