Database Software

Hi,

I am trying to learn how to import a CSV file into an oracle table. I tried the import utility in SQL Loader but it generates specific lines of code to import each row. I would want a loop to go through the CSV file stored on my local drive and have it uploaded to my table.

I have tried the following but no luck
LOAD DATA
INFILE 'sample_csv.csv'
INTO TABLE TEST
FIELDS TERMINATED BY ","
;