SQL Loader

Hello there,

I have a semicolon delimited text file (lets say 'c:\myfile.txt').

I want to insert it into a table in a 8.1.6 oracle database (lets say 'mydatabase.dbo.mytable')

I tried searching the internet for some scripts, but I get an error message "LOAD DATA not a recognised command" or something like this.

Could someone PLEASE help me? I'm a newbie in oracle. MS SQL procedure importing text files (bulk insert) is a lot easier in my opinion.

Thank you for your time...

re: SQL Loader

try the following

re: SQL Loader

Should I create the table before this procedure or not?

Thanks a lot debasisdas!!!!

re: SQL Loader

yes table must exist before the laoding.

the code is not a procedure

you need to put that in a control file and execute that from command prompt