Alvin	Tolliver	 1976 
Baer		 1234 
Mary	Dube	 1973 

CREATE TABLE SCOTT.emp_load (first_name CHAR( 15 ), last_name CHAR( 20 ), year_of_birth INT)
  ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY "FILE_DIR"
                         access parameters (
                          RECORDS DELIMITED by X'0D0A' 
    BADFILE 'test.bad' DISCARDFILE 'test.dsc' logfile 'test.log'
                         FIELDS TERMINATED by X'09' 
                         MISSING FIELD values ARE null)
                         LOCATION ('test.txt'));

FIRST_NAME      LAST_NAME            YEAR_OF_BIRTH          
--------------- -------------------- ---------------------- 
Alvin           Tolliver              1976                    
Baer                                  1234                    
Mary            Dube                  1973     

CREATE TABLE SCOTT.emp_load (first_name CHAR( 15 ), last_name CHAR( 20 ), year_of_birth INT)
  ORGANIZATION EXTERNAL (TYPE ORACLE_LOADER DEFAULT DIRECTORY "FILE_DIR"
                         access parameters (
                          RECORDS DELIMITED by X'0D0A' 
    BADFILE 'test.bad' DISCARDFILE 'test.dsc' logfile 'test.log'
                         FIELDS TERMINATED by X'09' optionally enclosed by '"'
                         MISSING FIELD values ARE null)
                         LOCATION ('test.txt'));


FIRST_NAME      LAST_NAME            YEAR_OF_BIRTH          
--------------- -------------------- ---------------------- 
Alvin           Tolliver              1976                    
Baer             1234                                         
Mary            Dube                  1973