Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help With External Table Definition
"Dereck L. Dietz" <dietzdl_at_ameritech.net> a écrit dans le message de news: %WS6g.11855$Lm5.1563_at_newssvr12.news.prodigy.com...
| I'm trying to create an external table definition.
|
| The only problem I am having is that the last field could be a null value
| and I have no idea how to define the external table to handle this. Here is
| the external table definition as it currently is:
|
| CREATE TABLE BIS.X_FRANCHISE
| ( franchise CHAR(3),
| franchise_name VARCHAR2(35),
| active CHAR(1),
| na_assoc CHAR(3) )
| ORGANIZATION EXTERNAL
| (
| TYPE ORACLE_LOADER
| DEFAULT DIRECTORY baseball_source
| ACCESS PARAMETERS
| (
| RECORDS DELIMITED BY NEWLINE
| NOBADFILE
| NOLOGFILE
| FIELDS TERMINATED BY ','
| (
| franchise,
| franchise_name,
| active,
| na_assoc
| )
| )
| LOCATION('teamsfranchises.txt')
| )
| REJECT LIMIT UNLIMITED
|
| Thanks.
|
|
In FIELDS clause add:
MISSING FIELD VALUES ARE NULL
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/et_params.htm#sthref1747
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14215/et_params.htm#i1009725
Regards
Michel Cadot
Received on Sat May 06 2006 - 03:33:57 CDT