Include it n your select statement
select emp||','||name||','||sal from emp;
This would return
10,MILLS,9
Here using comma as a delimiter
Ramon E. Estevez
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
809-565-3121
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL
You can not specify the record delimiter with UTL_FILE.
You can use UTL_FILE.GET_LINE to read records terminated with LF. LF will
not be included in the return string.
Igor Neyman, OCP DBA
Perceptron, Inc.
(734)414-4627
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of
Does utl_file not just read the file a line at a time and then it is upto
you to programmatically divide the data up into it's chunks using substr
etc.
Kev.
hit any user to continue
__
Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs