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 ;