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?
How do I load a flat file with delimited data into a Oracle Table?
Subscribe / Share
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.