CBSE Class 12 Informatics Practices Triggers Notes

Download CBSE Class 12 Informatics Practices Triggers Notes in PDF format. All Revision notes for Class 12 Informatics Practices have been designed as per the latest syllabus and updated chapters given in your textbook for Informatics Practices in Class 12. Our teachers have designed these concept notes for the benefit of Class 12 students. You should use these chapter wise notes for revision on daily basis. These study notes can also be used for learning each chapter and its important and difficult topics or revision just before your exams to help you get better scores in upcoming examinations, You can also use Printable notes for Class 12 Informatics Practices for faster revision of difficult topics and get higher rank. After reading these notes also refer to MCQ questions for Class 12 Informatics Practices given on studiestoday

Revision Notes for Class 12 Informatics Practices Triggers

Class 12 Informatics Practices students should refer to the following concepts and notes for Triggers in Class 12. These exam notes for Class 12 Informatics Practices will be very useful for upcoming class tests and examinations and help you to score good marks

Triggers Notes Class 12 Informatics Practices

,sans-serif;">syntax :

ALTER TRIGGER trigger_name DISABLE;

For example:

ALTER TRIGGER orders_before_insert DISABLE;

Drop a Trigger

syntax :

DROP TRIGGER trigger_name;

For example:

DROP TRIGGER orders_before_insert;

Example:

create or replace trigger check_budget_EMP

after insert or update of SAL, DEPTNO on EMP

declare

cursor DEPT_CUR is select DEPTNO, BUDGET from DEPT;

DNO DEPT.DEPTNO%TYPE;

ALLSAL DEPT.BUDGET%TYPE;

DEPT_SAL number;

begin

open DEPT_CUR;

loop

fetch DEPT_CUR into DNO, ALLSAL;

exit when DEPT_CUR%NOTFOUND;

select sum(SAL) into DEPT_SAL from EMP where DEPTNO = DNO;

if DEPT_SAL > ALLSAL then

raise_application_error(-20325, 'Total of salaries in the department '|| to_char(DNO) || ' exceeds

budget');

end if;

end loop;

close DEPT_CUR;

end; /

More about triggers :

Triggers are not exclusively used for integrity maintenance. They can also be used for

• Monitoring purposes, such as the monitoring of user accesses and modifications on certain sensitive

tables.

• Logging actions, e.g., on tables: Contd..

create trigger LOG EMP

after insert or update or delete on EMP

begin

if inserting then

insert into EMP LOG values(user, ’INSERT’, sysdate); end if ;

if updating then

insert into EMP LOG values(user, ’UPDATE’, sysdate); end if ;

if deleting then

insert into EMP LOG values(user, ’DELETE’, sysdate); end if ;

end;

By using a row trigger, even the attribute values of the modified tuples can be stored in the table EMP LOG.

• automatic propagation of modifications. For example, if a manager is transferred to another department, a trigger can be defined that automatically transfers the manager’s employees to the new department.

More about Triggers

If a trigger is specified within the SQL*Plus shell, the definition must end with a point “.” in the last line. Issuing the command run causes SQL*Plus to compile this trigger definition.

A trigger definition can be loaded from a file using the command @. Note that the last line in the file must consist of a slash “/”.

A trigger definition cannot be changed, it can only be re-created using the or replace clause.

The command drop deletes a trigger.

After a trigger definition has been successfully compiled, the trigger automatically is enabled.

The command alter trigger disable is used to deactivate a trigger. All

triggers defined on a table can be (de)activated using the command

alter table enable | disable all trigger;

The data dictionary stores information about triggers in the table USER TRIGGERS. The information includes the trigger name, type, table, and the code for the PL/SQL block.

Difference b/w For and Do Loops: When No. of repetitions are known then For loop is used, and if the No. of iterations are unknown then do loops are used.

Please click the link below to download pdf file for CBSE Class 12 Informatics Practices Triggers Study Notes

More Study Material

CBSE Class 12 Informatics Practices Triggers Notes

We hope you liked the above notes for topic Triggers which has been designed as per the latest syllabus for Class 12 Informatics Practices released by CBSE. Students of Class 12 should download and practice the above notes for Class 12 Informatics Practices regularly. All revision notes have been designed for Informatics Practices by referring to the most important topics which the students should learn to get better marks in examinations. Studiestoday is the best website for Class 12 students to download all latest study material.

Notes for Informatics Practices CBSE Class 12 Triggers

Our team of expert teachers have referred to the NCERT book for Class 12 Informatics Practices to design the Informatics Practices Class 12 notes. If you read the concepts and revision notes for one chapter daily, students will get higher marks in Class 12 exams this year. Daily revision of Informatics Practices course notes and related study material will help you to have a better understanding of all concepts and also clear all your doubts. You can download all Revision notes for Class 12 Informatics Practices also from www.studiestoday.com absolutely free of cost in Pdf format. After reading the notes which have been developed as per the latest books also refer to the NCERT solutions for Class 12 Informatics Practices provided by our teachers

Triggers Notes for Informatics Practices CBSE Class 12

All revision class notes given above for Class 12 Informatics Practices have been developed as per the latest curriculum and books issued for the current academic year. The students of Class 12 can rest assured that the best teachers have designed the notes of Informatics Practices so that you are able to revise the entire syllabus if you download and read them carefully. We have also provided a lot of MCQ questions for Class 12 Informatics Practices in the notes so that you can learn the concepts and also solve questions relating to the topics. All study material for Class 12 Informatics Practices students have been given on studiestoday.

Triggers CBSE Class 12 Informatics Practices Notes

Regular notes reading helps to build a more comprehensive understanding of Triggers concepts. notes play a crucial role in understanding Triggers in CBSE Class 12. Students can download all the notes, worksheets, assignments, and practice papers of the same chapter in Class 12 Informatics Practices in Pdf format. You can print them or read them online on your computer or mobile.

Notes for CBSE Informatics Practices Class 12 Triggers

CBSE Class 12 Informatics Practices latest books have been used for writing the above notes. If you have exams then you should revise all concepts relating to Triggers by taking out a print and keeping them with you. We have also provided a lot of Worksheets for Class 12 Informatics Practices which you can use to further make yourself stronger in Informatics Practices

Where can I download latest CBSE Class 12 Informatics Practices Triggers notes

You can download notes for Class 12 Informatics Practices Triggers for latest academic session from StudiesToday.com

Can I download the Notes for Triggers Class 12 Informatics Practices in Pdf format

Yes, you can click on the link above and download notes PDFs for Class 12 Informatics Practices Triggers which you can use for daily revision

Are the revision notes available for Triggers Class 12 Informatics Practices for the latest CBSE academic session

Yes, the notes issued for Class 12 Informatics Practices Triggers have been made available here for latest CBSE session

How can I download the Triggers Class 12 Informatics Practices Notes pdf

You can easily access the link above and download the Class 12 Notes for Informatics Practices Triggers for each topic in Pdf

Is there any charge for the Class 12 Informatics Practices Triggers notes

There is no charge for the notes for CBSE Class 12 Informatics Practices Triggers, you can download everything free of charge

Which is the best online platform to find notes for Triggers Class 12 Informatics Practices

www.studiestoday.com is the best website from which you can download latest notes for Triggers Informatics Practices Class 12

Where can I find topic-wise notes for Class 12 Informatics Practices Triggers

Come to StudiesToday.com to get best quality topic wise notes for Class 12 Informatics Practices Triggers

Can I get latest Triggers Class 12 Informatics Practices revision notes as per CBSE syllabus

We have provided all notes for each topic of Class 12 Informatics Practices Triggers as per latest CBSE syllabus