We are looking to export a file as .sql from a system in PHP to Oracle. We have individual orders generated in the system and need to export them so we can import into a .tmp table in Oracle. The head and the details in the body are to be copied into a table. We are looking to consolidate this data and export as a table with all the data, within a range and also as individual files for each order entry. If you need more details this is a simple job but from a bigger project.
We need this to be done ASAP as it is a test for a bigger job with the same system. For now, we can do the process manually, but need to automate if you are able to pull it through.