Hi,

In order to load data from a text file to a table you use oracle provided utility SQL*Ldr. This utility takes your text file and also a control file which has the parameters to control the behaviour of the load:Like

what it suppose to do if data is not formatted ?
what it should do if one of the column to which you are loading doen't have a value ?
what kinda load method(direct/conventional) it should use for load ?
what if the record is bad...'

---
---

and so on..

So you have to give this ctl file also as input along with your text file as input.

I am just giving high level information here. you better go thru documentation of Oracle Utilities(SQL Loader). I don't have actual syntax on top of my head thats why. Feel free to e-mail me if you need further information.