PL/SQL STORED PROCEDURE for DATA Insert and Capture activity in the Log table:
Simple stored procedure to insert data into the EMP table in SCOTT schema and each successful insert will be logged into the log table( scott.procedure_logtable ) and the data in the log table records will be purged if the Create_timestamp of Log table is 180 days old by scheduling the Purge Procedure " Purge_scott_logtable" with the schedular Job " Run_Purge_scott_logtable_job" Also, the log table will capture the user info on who changed data and from which machine the SQL was executed. LOG TABLE: SQL> Create table scott.procedure_logtable( Activity Varchar2(40), Created_by Varchar(10), Create_timestamp Date, From_machine Varchar(50) ) tablespace users; EMP TABLE: Name Null? Type -------- -------- ------------ EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10)...