RE: utl_file and record delimters

2001-10-24 Thread Ramon Estevez
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

Re: utl_file and record delimters

2001-10-24 Thread Igor Neyman
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

RE: utl_file and record delimters

2001-10-24 Thread Thomas, Kevin
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