I’m working on writing a pl/sql package to read the flat file, parse the data and load it into the table using UTL_FILE.fopen, DBMS_LOB.OPEN.
I'd like to take some sessions related to this topic if Oracle training center conduct. Can someone suggest which course would best fit?
This most certainly isn't the correct place to ask, and I don't even know what courses you like to attend. However; the course do not reinvent the wheel might be apropriate.
This is exactly what external tables are for: