Database Utilities (MOSC)

MOSC Banner

Need to explore the possiblity of external table with optional columns in CSV highlighted

I have the external table with table definition as

CREATE TABLE "PRE_STAGE"."CWS_SECURITYDETAILS_VW"
( "TICODE" VARCHAR2(12 CHAR),
"TIDM" CHAR(4 CHAR),
"SEDOL" CHAR(7 CHAR),
"COUNTRYOFREGISTER" CHAR(2 CHAR),

"PROFINVESTONLY" VARCHAR2(1 CHAR),
"PVLB" VARCHAR2(1 CHAR),
"ACCESS_BONDS_CREST" VARCHAR2(1 CHAR),
"SPECIFIED_DENOMINATION" NUMBER(18,8)

)
ORGANIZATION EXTERNAL
( TYPE ORACLE_LOADER
DEFAULT DIRECTORY "DUMP_S3_DIR"
ACCESS PARAMETERS
( RECORDS DELIMITED BY '$#@$#@\n'
CHARACTERSET AL32UTF8
STRING SIZES ARE IN CHARACTERS
SKIP 1
BADFILE DUMP_S3_DIR:'BAD_CWS_SECURITYDETAILS_VW_%a_%p.bad'
LOGFILE DUMP_S3_DIR:'LOG_CWS_SECURITYDETAILS_VW_%a_%p.log'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center