Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQLPLUS vs PL/SQL question
I need to change the value in one column of a table by adding the value of a
column in a different table to it and putting the result back into the original
column of the first table i.e. I want
column 1 of table 1 to equal column 1 of table 1 plus column 2 of table 2.
I know how to do it in PL/SQL with variables etc, but is there a way in SQLPLUS
to achieve the same result?
TIA Received on Tue Jun 23 1998 - 09:15:04 CDT