how to store old value in table when update in db

Question

HI FRNDS

 

i have insert the data in db .

here i m assign task to some and store data in another table .

i have a table like user id, assign , date, Creadted by , category

now i insert the data form the data base using assign dropdown list and save to another table and update also

and my another table where i changed assign data to some save in below table

user id, assign , date, category

here also updated data successfully

but if i update the data so want to see old value in this table how to do this

means if i update dropdownlist means assign to other old value how to show in table .

create or replace PROCEDURE RECORD_INSERT_ASSIGN
(
P_USER_ID NUMBER,
P_ASSIGN VARCHAR2,

P_CREATED_DT DATE,
P_USER_ID OUT NUMBER
)
AS

BEGIN

END RECORD_INSERT_ASSIGN ;