Pages

Ads 468x60px

Sunday, 3 June 2012

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;

0 comments:

Post a Comment

Total Pageviews