[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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.