1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
CREATE TABLE SQLLDR_TABLE
(
TYPE_ENREGISTREMENT VARCHAR2(2),
CHAMP1 VARCHAR(5),
CHAMP2 VARCHAR(5),
CHAMP3 VARCHAR(5),
CHAMP4 VARCHAR(5),
CHAMP5 VARCHAR(5),
CHAMP6 VARCHAR(5),
CHAMP7 VARCHAR(5)
)
ORGANIZATION EXTERNAL
(
TYPE oracle_loader DEFAULT DIRECTORY SQLLDR_TABLE_TMPDIR_00000
ACCESS PARAMETERS
(
RECORDS DELIMITED BY NEWLINE
LOAD WHEN
(
(TYPE_ENREGISTREMENT = '50')
AND (CHAMP1 != BLANKS)
AND (CHAMP2 != BLANKS)
AND (CHAMP3 != BLANKS)
AND (CHAMP4 != BLANKS)
AND (CHAMP5 != BLANKS)
AND (CHAMP6 != BLANKS)
AND (CHAMP7 != BLANKS)
)
BADFILE SQLLDR_TABLE_TMPDIR_00001:'&1..bad'
LOGFILE SQLLDR_TABLE_TMPDIR_00002:'&1..log'
DISCARDFILE SQLLDR_TABLE_TMPDIR_00001:'&1..dsc'
FIELDS TERMINATED BY "|"
(
TYPE_ENREGISTREMENT CHAR(2),
CHAMP1 CHAR(5),
CHAMP2 CHAR(5),
CHAMP3 CHAR(5),
CHAMP4 CHAR(5),
CHAMP5 CHAR(5),
CHAMP6 CHAR(5),
CHAMP7 CHAR(5)
)
)
LOCATION (SQLLDR_TABLE_TMPDIR_00000:'&1')
) |
Partager