Friday, April 25, 2014
Home » Oracle » Tools » How To Perform A Text Import With PL/SQL Developer

How To Perform A Text Import With PL/SQL Developer

PL/SQL Developer

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.

[showAdsenseInner]

Introduction

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.

UPDATE 4/9/2013: Hey guys, TJ here. I had to import some data from Excel via a .CSV file myself today, and had some struggles. Everything ended up on ONE line under the “File Data” part. The reason ended up being that I had to save the .CSV as a file using Unix type of EOL characters. Solved this by opening the file in Notepad++, change the EOL format, and then save it.

In this video we will

  1. Create a table named “customer”
  2. Import a .CSV text file into the table
  3. 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.

~ TJ

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. [showAdsenseInner] Introduction Working with Oracle SQL and PL/SQL since ...

Review Overview

Rate this

Summary : If you enjoyed this post, rate it to let other people know what you think. Hey...don't forget to share as well :-)

User Rating: Be the first one !
0

About TJ Abrahamsen

TJ Abrahamsen is the founder and author of OracleTuts. He has worked with Oracle since 1997. His expertise is with Oracle SQL and PL/SQL. He loves teaching others, and like to share his thoughts, ideas, and experience on his blog.
  • Jay

    I’ve imported text from CSV via the text importer in the past with no problem. I’m now trying to import a large file ~110 cols and 21,000+ rows. Each time I run the process, it loads only a few rows: 32 the first time, 23 the second time, 11 the third time. No errors. The manual says it’s possible to import a file of virtually any size. I’ve done this before with up to at least 10,000 recs.

    Any suggestions?

    • http://oracletuts.net TJ Abrahamsen

      Hello Jay. Sorry for the slow feedback. I have been out of town. :-)

      I have not tried using this on a lot of records. One issue I had earlier, was that I needed to have the right EOL character for each record. I think it needed a Unix type of EOL.

      I will try to import a large file and see what I experience.

      BTW – You should make sure that if you i.e. are using a “,” (comma) as a delimiter, how are you handling the text fields that have a comma in them, etc. If you are not somehow handling these cases, your records will end up being totally skewed and messed up. This might be one of your issues..?