Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How to handle newlines in files via PL/SQL
Hi, I need help with the followin procedure:
Procedure TEST
IS
file_in UTL_FILE.FILE_TYPE;
BEGIN
file_in := UTL_FILE.FOPEN ('F:\SAPJ\Files', 'koez.txt', 'W'); UTL_FILE.PUT (file_in, '1'); UTL_FILE.PUT (file_in, '11'); UTL_FILE.NEW_LINE (file_in); UTL_FILE.PUT (file_in, '2'); UTL_FILE.FCLOSE(file_in);
Output:
row 1: 111 row 2: 2 row 3:
!jani Received on Thu Jun 27 2002 - 06:10:02 CDT
![]() |
![]() |