Re: Updating a table from SQL

["Dray, Adam" <Adam.Dray@PHH.COM>]

Each INSERT statement can only update one row.  You will need multiple
INSERT statements to do it that way.

I recommend you use a BCP (bulk copy) utility.  I assume Oracle has one.
This will allow you to import an entire file into a table in a single
statement.

Good luck.

> -----Original Message-----
> From: Michael Prodor [SMTP:mprodor@QUALCOMM.COM]
> Sent: Wednesday, September 22, 1999 1:41 PM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Updating a table from SQL
>
> Is there an easy way to update / inserting into  a table, using a flat
> file
> at the UNIX level? We are currently running Oracle 8 on Sun.
>
> I've tried building a statement that looks like:
>
> INSERT INTO blah
>   (a,b,c,d,e)
> VALUES
>   ('A',2,3,4,5),
>   ('B',9,8,7,6),
>    ('C', 5,4,3,2),
> .
> .
> .
>
> but I keep getting a syntax error.
>
> Any help would be appreciated.