update table

From: Gloria Zhao <gloriaz_ca_at_yahoo.com>
Date: 24 Sep 2001 09:38:27 -0700
Message-ID: <fcb331b6.0109240838.52590692@posting.google.com>

Hi there,

Is it possible to update a table as the following in Oracle:

update table1 set * = (select * from table2 where table1.key= table2.key);

If it's inpossible doing it in sqlplus, is there any other similiar solutions in PL/SQL? I mean some special functions which could let us update all columns in table1 with the info in table1 where the the records in table1 and table2 have the same key.

Thanks a lot in advance.

Gloria Received on Mon Sep 24 2001 - 11:38:27 CDT