SQL & PL/SQL

Hi ALL,

Could you please advise me is the below approach possible or not ?

Requirement:-

I want to display the output in two rows, with passing data in single row.

Example:

select l_output1,l_output2 from dual;

Then my output should display like:

l_output1

l_output2

(Not as l_output1 l_output2)

I tried as below but it is not working,

select l_output1||chr(10)||l_output2 from dual

but still it is printing in single line. (CHR(10) for new line feed)

Thanks in advance.

Regards,

Uva