SQL & PL/SQL

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!

How to do interpolation in oracle

406871Apr 6 2005 — edited Apr 8 2005

Hello All,
I have minutely level data in the table and I wanted to add these minutely level data for every half an hour and store it seperatly

time value
eg: 06-apr-2004 10:01:00 10
06-apr-2004 10:02:00 12
06-apr-2004 10:03:00 14
06-apr-2004 10:04:00 NULL
06-apr-2004 10:05:00 16
.......
06-apr-2004 10:29:00 14
06-apr-2004 10:30:00 20

The Provblem I am having is In between in an half an hour data their might be null values and I have to "INTERPOLATE" these values and populate the missing value. Can any one please suggest me how to do this in oracle

Locked Post

New comments cannot be posted to this locked post.

Locked on May 6 2005

Added on Apr 6 2005

10 comments

2,477 views