The LOAD DATA statement is required at the beginning of the control file.

The INFILE option specifies where the input file is located

Specifying BADFILE, then bad records found during loading will be stored in this file.

Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.

Field Seperator - how the fields are separated in input file.

The LOAD DATA statement is required at the beginning of the control file.

The INFILE option specifies where the input file is located

Specifying BADFILE, then bad records found during loading will be stored in this file.

Specifying DISCARDFILE , then records which do not meet a WHEN condition will be written to this file.

Field Seperator - how the fields are separated in input file.

INSERT

APPEND

REPLACE TRUNCATE

DELETE UPDATE

INSERT : Loads rows only if the target table is empty

APPEND: Load rows if the target table is empty or not.

REPLACE: First deletes all the rows in the existing table and then, load rows.

TRUNCATE: First truncates the table and then load rows.

Conventional

Direct

Indirect

Insert

True

False

True

False

True

False

Tables are not clustered.

Tables to be loaded do not have any active transactions pending.

Loading a parent table together with a child Table

Loading BFILE columns

LF

HG

HNG

FP

True

False

True

False

HG,LF,HNG

DATE,DTTM,CMP,WD

TIME

None of the above

5000

10000

3000

1500

select * from EMP where nvl(EMPNO, '00000') = '59384';

select * from EMP where EMPNO = '59384';

select EMPNO, LASTNAME from EMP where EMPNO = '59384';

select 1 from EMP where EMPNO = '59834';

1

2

3

4

Primary key access

Access via unique index

Table access by ROWID

Full table scan

Column

1966_Invoices

Catch_#22

#Invoices

DROP

DELETE

CASCADE

TRUNCATE

INSTR

SUBSTRING

SUBSTR

POS