Need Help Loading a csv file

[bigpapi]

Hey folks;

I am pretty new at using PL/SQL developer and i need some help on the best or easiest way to load a file and do some work with it.

I have all my select statements ready to go for once i'm able to load the file, but right now, i don't know how to load the file or read it.

Can someone please help me out, it would be very much appreciated. I am using PL/SQL developer 7.1.1.1339

thanks in advance

 

[jko]

check out tools > text importer (very nice tool )

 

[bigpapi]

yeah i am currently looking at it at the moment.

My only question with it and maybe you or someone else can help.

If i use this tool in a development environment. Would i then have to use the same tool in a live production environment???

A script would be more of what i need i think, but the tool is very sleek for sure....

 

[mike]

If this is a one time load, you can use the "Export Table" tool to export the table into SQL insert statements after using the text importer tool. That script could be used to load production. Of course, you would want to test the script to make sure it works as planned.

If the data is going to change, you could look into using SQL loader, or using an external table. I believe 9i and above is required for external tables.

Mike