C:\sqlldr>rem sample session

C:\sqlldr>type dept.dat
10,ACCOUNTING,NEW YORK
20,RESEARCH,DALLAS
30,SALES,CHICAGO
40,OPERATIONS,BOSTON
trailerrecord
C:\sqlldr>deletelastline.bat dept.dat
        1 file(s) copied.

SQL*Loader: Release 9.2.0.1.0 - Production on Tue Jul 26 15:50:23 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 4

C:\sqlldr>sqlplus -s scott/tiger@mutation
select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON

exit;


C:\sqlldr>rem codes used
 
C:\sqlldr>type deletelastline.bat
@echo off
rem ----------------------------------------------------------
rem following are comments
rem ----------------------------------------------------------
rem deletelastline.bat is the batch file that takes two inputs
rem first input name of the file whose line(s) need to be deleted
rem        start from lastline
rem second input count of lines to be deleted.
rem        default is 1.
rem Just to be in safe side, before deleting the last i am copying
rem         the original file to filename.moved.
rem Now use sqlldr as usual and load the text file
rem ------------------------------------------------------------
copy %1 %1.moved
if {%1}=={}  @echo Syntax: DelLastLines FileName [NumLines]&goto :EOF
if not exist %1 @echo DelLastLines File %1 not found.&goto :EOF
setlocal ENABLEDELAYEDEXPANSION
set /a num=1
if not {%2}=={} set /a num=%2
set wrk="%TEMP%\DelLastLines.tmp"
set fle=%1
if exist %wrk% del /q %wrk%
for /f %%n in ('find /V /C "" ^<%fle%') do set /a nbr=%%n
set /a nbr=%nbr% - %num%
for /f "tokens=1,* delims=[]" %%K in ('find /V /N "" ^<%fle%') do (
 set /a cnt=%%K
 if !cnt! LEQ %nbr% @echo/%%L>>%wrk%
)
call :cpy >nul 2>&1
del /q %wrk%
endlocal
goto :sqlload
:cpy
copy /Y %wrk% %fle%
:sqlload
rem -------------------------
rem invoke sql*loader
rem i have hardcoded the filename dept.dat in control file.
rem you can pass it in runtime.
rem -------------------------
sqlldr userid=scott/tiger@mutation control=dept.ctl
goto :EOF

C:\sqlldr>type dept.ctl
LOAD DATA
infile 'dept.dat'
replace INTO TABLE dept FIELDS TERMINATED BY "," trailing nullcols
(
deptno,
dname,
loc
)

C:\sqlldr>