Re: sqlload control file

Marc Mangus wrote:
>
> Hi folks,
>
> I'm trying to load some text files into my OES 7.3.2 server running on
> Solaris 2.5.1. I've been beating my head against the desk trying to get
> the control file just right. The syntax is insane. Does anyone have
> any sample control files they can post? I've dealing with
> fixed-position ascii files. Thanks!

load data
infile 'easy.dat'
into table ingrid

( timestamp      sysdate,
  pid            position (1:5) char,
  lname          position (6:25) char,
  fname          position (26:55) char)

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################