In this video I will show you how you can use PL/SQL Developer from Allround Automations to import a text file, in my case a .CSV file into a simple table.
This tool can be used for many types of data imports into an Oracle table.
Working with Oracle SQL and PL/SQL since 1997, I have done a LOT of text import of data. Usually what I have done is to open i.e. a .CSV file in Excel, and add columns, so that when I save the file back to the .CSV file again, it creates a series of INSERT INTO statements. This way of preparing the data, and then import the data is just time consuming. There is a much better way.
In this video we will
- Create a table named “customer”
- Import a .CSV text file into the table
- Select from the “customer” table
Very simple, this tool is just awesome.
If you have any other experiences with this text import tool, please leave a comment so that we all can know a bout it.