Oracle Database Discussions

I have a requirement which is nothing but a table has two column

create table emp_data (empid number, report clob)

Here REPORT column is CLOB data type which used to load the data from the .csv file.

The requirement here is

1) How to load data from .CSV file into CLOB column along with empid using DBMS_lob utility
2) How to read report columns which should return all the columns present in the .CSV file (dynamically because every csv file may have different number of columns) along with the primariy key empid).

eg: empid report_field1 report_field2
1 x y

Any help would be appreciated.