Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQLPLUS vs PL/SQL question

SQLPLUS vs PL/SQL question

From: Iancrozier <iancrozier_at_aol.com>
Date: 23 Jun 1998 14:15:04 GMT
Message-ID: <1998062314150400.KAA26085@ladder03.news.aol.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US