Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Conversion of Update from MSSQL generates "SQL command not properly ended"
Try put ; at the end of the statement.
M.
"Puck" <calchris2002_at_yahoo.com> wrote in message
news:d62bc31c.0407231316.60c08386_at_posting.google.com...
> Oracle 9i (9.0.2)
>
> Using an update like the following:
>
> update table1 set table1.col1 = table2.col1, table1.col2 = table2.col2
> from table1,table2 where table1.recid = table2.recid and table2.recid
> in (1234,4567)
>
> Generates the "SQL Command not properly ended" error.
>
> What would be the proper way of doing this under Oracle 9 (the above
> is what we used under MS SQL)? All the solutions I have seen have been
> for 1 record returned or 1 record updating multiple records.
>
> TIA
Received on Fri Jul 23 2004 - 16:50:26 CDT