Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Correlated Update

345374Nov 4 2002 — edited Jul 15 2003

Anyone have a suggestion to get OWB to generate a correlated update? The requirment is to populate a column called intrvl that contains the number of minutes between 2 adjacent effective dated rows. Here's the code that must be implemented...

update tablea t2
set intrvl =
(select (t2.effdate - t1.effdate) * 24 * 60
from tablea t1
where t1.effdate =
(select max(effdate) from tablea
where effdate < t2.effdate))

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 12 2003

Added on Nov 4 2002

#data-warehousing, #warehouse-builder

8 comments

488 views