Re: Oracle Update

From: G Quesnel <dbaguy_ott_at_yahoo.com>
Date: 19 Apr 2006 11:45:13 -0700
Message-ID: <1145470848.344258.249190@i39g2000cwa.googlegroups.com>

You can create a pseudo table, made up of several tables joined together, provided they have the proper unique key linking them together.
For example...
Update (Select t1.cval cv1, t3.cval cv3, t1.c_flag cf1, t3.c_flag cf3

               from t1, t2, t3
               where t1.cpk = t2.cpk and t2.cfk = t3.cpk) tv
   set tv.cv1 = tv.cv3,
        tv.cf1  = tv.cf3

  where tv.cv3 is not null;

This is just an example of a possible approach. If you provide more information, then we may be able to provide a better solution.

hth Received on Wed Apr 19 2006 - 13:45:13 CDT