PL SQL Program For counting record using trigger.

PL SQL Program For counting record using trigger.

create or replace trigger counts AFTER insert on TRISTUDENT
declare
c interger;
begin
select count(*) into c from tristudent;
dbms_output.put_line('total records : '||c);
end;

DBMS

PL SQL Program For counting record using trigger.

create or replace trigger counts AFTER insert on TRISTUDENT
declare
c interger;
begin
select count(*) into c from tristudent;
dbms_output.put_line('total records : '||c);
end;

PL SQL Program For counting record using trigger.

create or replace trigger counts AFTER insert on TRISTUDENT declare c interger;beginselect count(*) into c from tristudent;dbms_output.put_line('total records : '||c);end;

create or replace trigger counts AFTER insert on TRISTUDENT
declare
c interger;
begin
select count(*) into c from tristudent;
dbms_output.put_line('total records : '||c);
end;