Good Morning/Afternoon/Evening:
I have a requirement where .json files are being dumped into a folder on my Oracle server, and those files need to be inserted into a table automatically. I've looked at the import/export feature in SQL developer, but I can't find online how to effectively set up an automated process (job) to import the records into an Oracle DB.
The .json files actually contain .xml data, and each file represents a row of data.
Any idea on the best way to approach this?
Thanks and kind regards,
Aqua