How do I upload pipe delimited text file to oracle database
Posted on 2013-01-10
I've created a new database and need to import a bunch of data to the tables. I'm looking for a method to do it through a script so that I can setup a process to upload all data going forward.
I'm really new to oracle, so I really don't know too much about how to go about doing this... But I've been recommended to use the SQL Loader. Would this do the job that I'm looking for? If so, could you give some examples or someplace I can get more details on how to go about loading these files? thanks!