DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: utl_file

  1. #1
    Join Date
    Mar 2002
    Posts
    303

    utl_file

    Hi all,

    I want to read in a loop lines of flat file and want to ignore the first line(Heading of the columns).
    How can i do?
    Thank's all

  2. #2
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588

    Code:
    nCnt := 0;
    hFile := UTL_FILE.FOPEN (sDirPath, sFileName, 'r');
    LOOP
       UTL_FILE.GET_LINE(hFile,sLine);
       nCnt := nCnt +1;
       IF nCnt > 1 THEN
          do you processing
       END IF;   
    END LOOP;

  3. #3
    Join Date
    Mar 2002
    Posts
    303
    Thank's

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width