<div>
What type of trigger?<br />
<br />
There are system level and table level. &nbsp;There are also &quot;instead of&quot; triggers for DML on views.<br />
<br />
The online documentation is the best place to start:<br />
<a href="http://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS020" rel="ugc">http://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS020</a>
</div>


What type of trigger?

There are system level and table level.  There are also "instead of" triggers for DML on views.

The online documentation is the best place to start:
http://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS020 [http://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS020]

<div>
Too many uses to enumerate. It's used wherever the occasion calls for it. Frequently it is used in conjunction with a sequence to generate an identity.
</div>


Too many uses to enumerate. It's used wherever the occasion calls for it. Frequently it is used in conjunction with a sequence to generate an identity.

<div>
Another important thing about trigger is that it slows down DML because for every DML Oracle has to invoke and execute Trigger code.
</div>


Another important thing about trigger is that it slows down DML because for every DML Oracle has to invoke and execute Trigger code.

<div>
<div class="content wysiwyg-content">
what is the use of trigger in oracle database. where exactly it is used which occassions.
</div>
</div>


what is the use of trigger in oracle database. where exactly it is used which occassions.

trigger

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.