aslam wa alikom
iam student in india and i am studying oracle i just want to ask a question if i want to create a table same like emp and name it emp1
and if i insert ,delete or update anything in emp the same actoin has to appear in emp1 so what code should i right
for that
plz help me
at the end i want to thank evry one working on this site
asking god to help us all
if anyone can help me no problem he can write it arabic or english

ممكن من نوع العلاقة بين الجدولين تحصل على ماتريد

اتوقع امكانية ذلك من خلال بناء trigger !

CREATE OR REPLACE TRIGGER AUDIT_WORK_ORDER
BEFORE INSERT OR UPDATE OR DELETE ON work_order
FOR EACH ROW
BEGIN
IF INSERTING THEN
INSERT INTO AUDITING_WORK_ORDER
VALUES(NULL,:NEW.m_code,NULL,:NEW.w_o_code,NULL,
:NEW.w_o_qty,null,:NEW.w_o_startdate,null,:NEW.w_o_finshdate,USER,'inseting',SYSDATE);
ELSIF DELETING THEN
INSERT INTO AUDITING_WORK_ORDER 
VALUES(:OLD.m_code,NULL,:OLD.w_o_code,NULL,
:OLD.w_o_qty,NULL,:OLD.w_o_startdate,NULL,:OLD.w_o_finshdate,NULL,USER,'DELETING',SYSDATE);
ELSE
INSERT INTO AUDITING_WORK_ORDER 
VALUES(:OLD.m_code,:NEW.m_code,:OLD.w_o_code,
:NEW.w_o_code,:OLD.w_o_qty,:NEW.w_o_qty,:OLD.w_o_startdate,:NEW.w_o_startdate,:OLD.w_o_finshdate,:NEW.w_o_finshdate,USER,'UPDATING',SYSDATE);
END IF;
END;

هذا ما تريد
بس انت عدل و فنن

ايهاب وجدى