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 -> Re: How to update 2 joinable tables in one satement ?

Re: How to update 2 joinable tables in one satement ?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 17 Apr 2002 06:47:52 +0200
Message-ID: <phvpbug641ipspnkivi6r1bbip2p1a2mr9@4ax.com>


On Tue, 16 Apr 2002 19:59:53 -0400, "R Chin" <rchin_at_panix.com> wrote:

>How can I update
>the joined records of
>EMP.colx and DEPT.coly
>in one statement ? Is this possible ?
>
>Thanks
>
>Robert
>-- 8.1.7/AIX --
>

Use an inline view.
update (select emp.colx, dept.coly from emp, dept where emp.deptno =
dept.deptno) set  ....

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Apr 16 2002 - 23:47:52 CDT

Original text of this message

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