Re: Updating a table from SQL

["Ying, Chenter" <CHENTER.YING@KLA-TENCOR.COM>]

if you use oracle, you must have access to a tool called sql*loader.  if not
sure, then ask your oracle dba.

-----Original Message-----
From: Michael Prodor [mailto:mprodor@QUALCOMM.COM]
Sent: Wednesday, September 22, 1999 10:41 AM
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.