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 -> Update statement syntax?

Update statement syntax?

From: HoMan <paulh_at_nospam.twoplus.com>
Date: Fri, 19 Feb 1999 12:25:40 -0500
Message-ID: <uimxDyCX#GA.50@nih2naad.prod2.compuserve.com>


The UPDATE statement in Transact-SQL can take the form: UPDATE tableA
  Set col = <expression>, ...
  FROM TableB, TableC
 WHERE <condition> ;

Is there a similar feature in Oracle syntax? The rows in TableA that need to be updated are based upon how they join to TableB and TableC.

Thanks,
Paul Horan Received on Fri Feb 19 1999 - 11:25:40 CST

Original text of this message

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