How do I load data from a FLAT file into oracle??

[Jonathan777]

HI,

Did an unload of a table from informix. I have this flat file that is "|" deliminited. How in heck do I go about loading data in a table that I already created in oracle. Thanks.

-Jon

 

[jimbopalmer]

In SQL Loader use LOAD DATA INTO TABLE mytable FIELDS TERMINATED BY '|' (firstcol, seccol, lastcol) rather than specify column positions as usual The one thing you can't give for your heart's desire is your heart. - Lois McMaster Bujold

 

[cwong5]

I usually use MS Access when I have to do such thing.