In this tutorial we are going to create a simple trigger to update the count when a new row is added.
(Please note that this tutorial is just to demonstrate a simple trigger,)
Create a table called EMP1. Refer this for more details about creating tables and inserting data
And create EMPCOUNT1 table too .
Create the trigger as depicted in the image.
insert into emp1 values ('7','sad','3000')
select * from empcount1
Above commands can be used to demonstrate the Trigger. Once a new row is inserted the count is incremented by 1. (Refer the trigger)
create or replace TRIGGER "COUNTTEST" BEFORE INSERT ON EMP1
FOR EACH ROW
set EMP_COUNT = EMP_COUNT +1;