Re: Need sql*loader help

From: Gary M. Greenberg <garyg_at_gator.net>
Date: Tue, 12 Jan 1999 22:24:37 -0500
Message-ID: <369C11F5.8F1E154B_at_gator.net>

Ryan,

> Here is what my control file looks like:
>
> LOAD DATA
> INFILE *
> INTO TABLE PROJECT
> FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY "'"

                                                    ^^^^ '"'

> TRAILING NULLCOLS
> ( projectnumber,
> projecttask,
> projectname
> )
> BEGINDATA
> "894001000","0000","Some Project Name"
>

btw, Is all your data defined as varchar2(X)?

Gary

            -=- Avenue Programmers' Reference -=-    Class Hierarchy, Requests, and Hyperlinked Sample Scripts:

             http:/www.gator.net/~garyg/aveclass.htm Received on Wed Jan 13 1999 - 04:24:37 CET