Re: SQL Question

From: W. Scott Moore <sirws_at_hotmail.com>
Date: 1999/12/01
Message-ID: <8id14.530$Rk2.19081_at_news.uswest.net>#1/1

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}]]

[FROM {table_name | view_name}

 [, {table_name | view_name}]...]
  [..., {table_name16 | view_name16}]]
[WHERE clause]

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...

[Quoted] > 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 - 00:00:00 CET