set COLSEP ,
Hi,
I want to send the rows returned in an EXCEL file (the column seperated by ","; a CVS file). Then I do :
SQL> set pages 0 feed off
SQL> set colsep ,
SQL> spool user_responsibilitie
SQL> select name,display_name from wf_local_roles
where display_name like 'AX%';
But the result is not good :
FND_RESP|AX|AX_GENERAL_LEDGER_USER_MRC|STANDARD
AX General Ledger User MRC
FND_RESP600:21632
AX General Ledger User MRC:Any security group
The columns are seperated by carriage return (next line).
Where is my error ?
Any help ?
DB VERSION 9.2.0 on Linux.