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
Printable View
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
:D
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;
Thank's