Re: PLSQL/ UPDATE statement

Try using "....where table1.col3 in (select col2 from table2)"

However, this might give you more than you want.

Kevin Burton wrote:

> In Sybase I have the ability to update columns in a table A by joining
> to another table B. The syntax is'
>
> UPDATE Table 1
> set table1.col1 = Table2.col1,
> table1.col2 = Table2.col3
> WHERE table1.col3 = Table2.col2;
>
> I can't do that in Oracle. Can I do this without creating a cursor? I want
> to be able to this in a stored procedure.
>
> - Kevin Burton
> pdsinc_at_csi.com

Received on Wed Jan 12 2000 - 10:06:46 CST