Hi Team
I have a requirement to modify the existing workflow to make it more efficient. This involves working with Oracle PL/SQL in version 19c. Here are the steps:
- Files are initially loaded into 'xyz.csv' located in the Unix directory '/u/apps/file/xyz.csv.'
- These files are then read from this location and converted into 'xyz.dat.'
- The xyz.dat.data is loaded into temporary tables.(using sqlloader) *csv file not accept
- The next step involves merging this data into the existing table using the temporary table.
Please let me know if there are any Oracle 19c features that can simplify this process.