Load Flat or CSV File to Oracle Using SQL Developer
SQL Developer can be used to load Text or CSV Files into the Oracle Database.
Also see • Using SQL Developer to Copy Data to the Or... on how to copy data from an On-Premises database to the Cloud (good for only small datasets) via SQL Developer
In this demo, I am loading to my Autonomous Data Warehouse Database in the Oracle Cloud. The rows retrieved by the query do not seem to be in the same order as in the CSV file. Oracle compresses all data loaded into the Autonomous Database. So, a query may not explicitly show the same ordering of rows unless a proper ORDER BY key was used.