1,2,3,
4,,6,
7,8,9,

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

Directory created.

scott@ORA92> CREATE TABLE test
  2    (col1		 NUMBER,
  3  	not_null_column  NUMBER,
  4  	col3		 NUMBER)
  5  ORGANIZATION external
  6    (TYPE ORACLE_LOADER
  7  	DEFAULT DIRECTORY my_dir
  8  	ACCESS PARAMETERS
  9  	  (RECORDS DELIMITED BY NEWLINE
 10  	   LOAD WHEN (not_null_column  != BLANKS)
 11  	   DISCARDFILE 'MY_DIR':'test.dsc'
 12  	   BADFILE     'MY_DIR':'test.bad'
 13  	   LOGFILE     'MY_DIR':'test.log'
 14  	   FIELDS TERMINATED BY ","
 15  	     (col1,
 16  	      not_null_column,
 17  	      col3))
 18    LOCATION ('test.dat'))
 19  /

Table created.

scott@ORA92> SELECT * FROM TEST
  2  /

      COL1 NOT_NULL_COLUMN       COL3
---------- --------------- ----------
         1               2          3
         7               8          9

scott@ORA92>  

4,,6,