PLSQL/ UPDATE statement

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