| ^L in the begin of the second line of the spool file [message #84197] |
Fri, 13 February 2004 01:44 |
khalid
Messages: 24
Registered: September 1999
|
Junior Member |
|
|
Hello,
I want to spool data in a file as below :
SET SERVEROUTPUT ON SIZE 1000000
SET NEWPAGE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEAD OFF
SET VERIFY OFF
SPOOL $BASE_DT/oracle/flux/sortie/sc_entreprises.txt
PROMPT PERE;FILS;ALIAS;Conso
select CODE||';'||
CHILDREN_CODE||';'||
CHILDREN_DESC||';'||
CONSO_CODE
from ENTERPRIS
order by NUM asc
/
spool off
exit;
in the begin of the second line of the spool file I have ^L why ?
PERE;FILS;ALIAS;Conso
^LENTREPRISES;;Total Entreprises;+
ENTREPRISES;08-TOTALE;08-TOTALE;+
08-TOTALE;01-HYPER;01-Hyper;+
Thank you for your help.
Khalid.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
