SQL & PL/SQL

Hi All,

I am spooling my sql output to an excel file and below is the code.

I am using custom package to spool the query.

l_heading :=

               'Empno'                            

            || ','                                    

            || '1234'            

            || CHR(10)

            || 'Ename'

            || ','

            || 'SCOTT' ;

--- ',' is the delimiter which is nothing but CHR(9) i.e tab

Expected O/P:

I am getting the below O/P:

I tried CHR(10) , CHR(13) || CHR(10) for a new line value. But, this splits the line within the cell.

Whereas, I want to print Ename on the next row of the excel.

Can anyone please help.

Thanks.