Update

   I have a question regarding to an update statement in Oracle. Ideally, I would like to do the following:

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

   This way I can update each record in table1 with table2 info without mentioning each column's name. If this is impossible to be done in sqlplus, is there any special functions to allow us to do the similar operation? Your help will be much appreciated.

Regards,

Gloria Received on Mon Sep 24 2001 - 18:46:54 CEST