I have a flat file with | delimited data that I need to do a one time manual load into a new table that is in the Oracle DB. Which sql functions do you recommend I use which will be easiest since I’m not very seasoned?
Categories
Tags
about answer Answers Anyone asked Auctions Best career CCNA Certification COMPUTER Cycle debugging Development exam find from good help Inheritance Interview JAVA know latest life microsoft need Oracle Please Programming question Questions should Software Some someone Tell Testing there these think this want Winform Would
SQL*Loader is the command line utility for loading data into Oracle. You’ll need to create an empty table and then a control file, which tells Oracle what format your data is in. There’s a good example here: http://68.142.116.70/docs/cd/B28359_01/text.111/b28304/aload.htm#CCREF2259
There are other methods, but this is available to anyone and relatively easy.