You can use the sql loader for upload the csv file into your database tables.

use the sql loader for upload csv file into database

Steps how to load?
1. create control file in notpad like

load data
infile 'path of csv file'
insert/append into file file_name
fields terminated by ' ,'
optionally enclosed by ' " '
trailing nullcols
(col1,col2,col3,.......)

2. Save this control with .ctl extension

3 Goto command prompt and run the query like

c:> sqlldr userid=apps/apps control =(path of ur control file with .ctl extension)