Help With External Table Definition

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Sat, 06 May 2006 01:26:19 GMT
Message-ID: <%WS6g.11855$Lm5.1563@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. Received on Fri May 05 2006 - 20:26:19 CDT