How to Import a CSV

If you have a CSV file you can import it into a table using the sqlldr command of Oracle with a control file. The control file specifies the csv file name, the delimiter, the destination table and the columns to populate.

-- Below is an example of the control file for the sqlldr command
LOAD DATA infile '/ipoapplication/utl_file/LBR_HE_Mar16.csv' 
REPLACE INTO TABLE LOAN_BALANCE_MASTER_INT 
fields terminated by ',' optionally enclosed by '"' 
    (	
        ACCOUNT_NO, 
        CUSTOMER_NAME, 
        LIMIT, 
        REGION 
    )
;

IN THIS PAGE