scott@ORA92> CREATE OR REPLACE DIRECTORY ext_tab_dir AS 'c:\oracle'
  2  /

Directory created.

scott@ORA92> CREATE TABLE emp_load
  2    (first_name    CHAR(15),
  3  	last_name     CHAR(20),
  4  	year_of_birth INT)
  5    ORGANIZATION EXTERNAL
  6  	 (TYPE ORACLE_LOADER
  7  	  DEFAULT DIRECTORY ext_tab_dir
  8  	  ACCESS PARAMETERS
  9  	    (FIELDS TERMINATED BY ","
 10  	     MISSING FIELD VALUES ARE NULL)
 11  	  LOCATION ('info.dat'))
 12  /

Table created.

scott@ORA92> SELECT * FROM emp_load
  2  /

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

scott@ORA92>