DELETE FROM emp;
DELETE FROM dept;
DELETE FROM OUTPUT;
DELETE FROM DATA_LOADS;
COMMIT;
HOST sqlldr80 userid=scott/tiger control=421ex.ctl
SET LINESIZE 255;
SET PAGESIZE 1000;
SET TRIMSPOOL ON;
SET HEADING OFF;
COLUMN line FORMAT A255;
SPOOL 421test.log
PROMPT Output from load
SELECT output_name||' '||LPAD(TO_CHAR(line_no),3)||': '||line_text line
FROM output
ORDER BY output_name, line_no;
SET HEADING ON;
SELECT * FROM dept;
SELECT * FROM emp;
SET HEADING OFF;
SELECT line_text
  FROM data_load_reports
ORDER BY interface_name, job_id, line_no;
SET HEADING ON;
SPOOL OFF;