Re: Updating a table from SQL

[Robert Buford <robertb@ABBASYS.COM>]

Hi Michael,

To my knowledge you have to do like this:

INSERT INTO blah (a,b,c,d,e) VALUES ('A',2,3,4,5)
INSERT INTO blah (a,b,c,d,e) VALUES ('B',9,8,7,6)
INSERT INTO blah (a,b,c,d,e) VALUES ('C', 5,4,3,2)

which I was able to do in less than 30 seconds cut & paste.

HTH

Bob
> -----Original Message-----
> From: Discussion of SQR, SQRIBE Technologies's database reporting
> language [mailto:SQR-USERS@list.iex.net]On Behalf Of Michael Prodor
> 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.
>