Creating an external table

It is possible to create a table based on a csv file using the following example.

 CREATE TABLE EXT_TABLE_EXAMPLE 
   (	"COL_A" VARCHAR2(250 BYTE), 
	"COL_B" VARCHAR2(250 BYTE), 
	"COL_C" VARCHAR2(250 BYTE), 
	"COL_D" VARCHAR2(250 BYTE)	
   ) 
   ORGANIZATION EXTERNAL 
    ( TYPE ORACLE_LOADER
      DEFAULT DIRECTORY "DIR"
      ACCESS PARAMETERS
      ( RECORDS DELIMITED BY NEWLINE
    BADFILE     DIR:'EXT_TABLE_EXAMPLE.bad'
    LOGFILE     DIR:'EXT_TABLE_EXAMPLE.log'
    DISCARDFILE DIR:'EXT_TABLE_EXAMPLE.dis'
 
    FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"'
    missing FIELD VALUES are NULL
      )
      LOCATION
       ( 'example.csv'
       )
    )
   REJECT LIMIT UNLIMITED;

The example assumes that you have placed example.csv within the Oracle directory called DIR.