Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!newsdst02.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr12.news.prodigy.com.POSTED!89d291a9!not-for-mail
From: "Dereck L. Dietz" <dietzdl@ameritech.net>
Newsgroups: comp.databases.oracle.server
Subject: Help With External Table Definition
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <%WS6g.11855$Lm5.1563@newssvr12.news.prodigy.com>
NNTP-Posting-Host: 70.141.182.137
X-Complaints-To: abuse@prodigy.net
X-Trace: newssvr12.news.prodigy.com 1146878779 ST000 70.141.182.137 (Fri, 05 May 2006 21:26:19 EDT)
NNTP-Posting-Date: Fri, 05 May 2006 21:26:19 EDT
Organization: SBC http://yahoo.sbc.com
X-UserInfo1: FKPO@MONQJTYB\@ZJBHD]V@APZXTPO\MAPVZKB]MPXHJUZ]CDVW[AKK[J\]^HVKHG^EWZHBLO^[\NH_AZFWGN^\DHNVMX_DHHX[FSQKBOTS@@BP^]C@RHS_AGDDC[AJM_T[GZNRNZAY]GNCPBDYKOLK^_CZFWPGHZIXW@C[AFKBBQS@E@DAZ]VDFUNTQQ]FN
Date: Sat, 06 May 2006 01:26:19 GMT
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:266986

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.