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

Explain the steps needed to create the scheduled job?

1034

Is crud a cuss word?

1028

What is Difference Between Unique and Primary Key Constraints?

1101

Inline the values in PL/SQL, what does it mean.?

1212

Do prepared statements prevent sql injection?

947

What do you mean by field in sql?

1075

What is null in pl/sql?

1061

what are different types of keys in sql?

1141

what are local and global variables and their differences? : Sql dba

1066

What is a crud api?

948

What is the use of function "module procedure" in pl/sql?

1190

what are the advantages a stored procedure? : Sql dba

972

What is the difference between functions, procedures, and packages in pl/sql?

1040

What is full join in sql?

984

What does an inner join do?

1175