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!

Manage History of a Table

ZiaFeb 26 2010 — edited Mar 2 2010

Hi Experts !

we have a table EMP with the record of our employs in fol columns

EMP_NAME
EMP_ID
BIRTH_DATE
EMPLOYMENT_DATE
RELIGION
PRESENT_ADDRESS
PHONE_NO

now out of these columns, several columns may change depending upon updates given by emps for example, EMP Jhon may change his address or EMP Micheal may change his phone no.

what we require is a mechanism to maintain the historical data of all these changes in out database for example we could have data of all the changes in ADDRESS column of EMP_ID 1, or data for all changes in PHONE_NO column of EMP_ID 2 and so on

might be a very poor requirement but the actual database has been there for years and now we cannot change the tables already created so have to find some way. columns can bee added but tables cannot be altered altogether.

Best Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2010

Added on Feb 26 2010

16 comments

1,794 views