how to import csv file to oracle 9i

[peus]

HI,
Can you please provide me tutorials or samples regarding how to import a csv file into oracle 9i. we're using toad.

[damon_cool]

You should search SQL*Loader, that is the tool you will need.

The first couple of search results that came up for me have good overviews on how to code SQL*Loader control and command files.

It seems complicated at first, but after you have done it once it's really pretty simple.

Damon