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 maintain historical data??????

984148Feb 3 2013 — edited Feb 5 2013

Hiii,,,

I will be very happy if anyone solve my question??????

I am trying to maintain historical data, I have created a table using materialized view ,and when ever i refreshed the table with new values the old value should move to the history table and the current table should updated with new values. I am using oracle 10g. can anyone tell how to do this.

Thankz in advance.

This post has been answered by Bawer on Feb 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 5 2013

Added on Feb 3 2013

#plsql

20 comments

4,498 views