trigger question 1

[slok]

I have a table as follows:

SQL> desc employee;
Name Null? Type
----------------------------------------- -------- ----------
EMP_NO NOT NULL NUMBER(4)
EMP_NAME NOT NULL CHAR(20)
EMP_SALARY NOT NULL NUMBER(8,2
EMP_SDATE NOT NULL DATE
DEPT_NO NOT NULL NUMBER(2)
ADDED_BY NOT NULL CHAR(20)


And a procedure Check_Delete as defined follows:
procedure Check_Delete (
p_user IN employee.added_by%type,
p_sysdate IN employee.emp_sdate%type)
as
===


How can I create a trigger that will called the procedure
Check_Delete before the actual delete?

 

[sschandhok]

create trigger <trigger-Name>
before delete on <any table namae other than the employee>
for each row
begin
check_deleteold.emp_no,ld.emp_sysdate);
end;

You should make emp_no as a primary key and then do the following:

Create a temp table so that you have two field(the parameters which you have written in the procedure) and then
when you delete the id from the temp file then automatically it deletes the record from the employee table

Let me know if there is any problem