Re: Updating a table from SQL

["Logu Chakravarthi (IT Dept. - Langley)" <logu_chakravarthi@OWFG.COM>]

You can use ODBC but I am not sure how it'll work in Unix. Import the file
to Access and then just export it to any database that have ODBC connection.

C.Logu

> -----Original Message-----
> From: Dray, Adam [SMTP:Adam.Dray@PHH.COM]
> Sent: 1999/09/22 10:47 AM
> To:   Multiple recipients of list SQR-USERS
> Subject:      Re: Updating a table from SQL
>
> 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.