Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Question
Actually, the syntax in T-SQL is:
UPDATE {table_name | view_name}
SET [{table_name | view_name}]
{column_list
| variable_list
| variable_and_column_list}
[, {column_list2
| variable_list2
| variable_and_column_list2}
... [, {column_listN
| variable_listN | variable_and_column_listN}]]
So you can use the FROM to specify multiple tables. What is the equivalent in PL/SQL?
Thanks,
Scott
W. Scott Moore <sirws_at_hotmail.com> wrote in message news:h_c14.516$Rk2.16787_at_news.uswest.net...
> I am trying to run an update: > > UPDATE SDE.CH_ADDRESS A, SDE.ADDRESS_PNT_at_MSGISPROD B > SET A.LOT_NUM = B.LOT_NUM, > A.PARCEL = B.PARCEL > WHERE A.LOT_NUM = 0 AND A.FULL_ADDRESS = B.FULL_ADDRESS > > but it doesn't seem to like the use of multiple update tables. I*believe*
> that I used this syntax in MS SQL 6.5... I think I must be a little rusty. > > Any help would be greatly appreciated. > > Sincerely, > W. Scott Moore > City of Chandler, AZ > >Received on Wed Dec 01 1999 - 11:59:27 CST