Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what is the different of application trigger and database trigger in PL/SQL

Re: what is the different of application trigger and database trigger in PL/SQL

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Wed, 24 Jul 2002 16:19:53 +0200
Message-ID: <ahmd7o$tp2tu$1@ID-152732.news.dfncis.de>


There are different opinions about what database triggers are: 1 Triggers that fire on database events like ON LOGON (available only in and after 8i)
2 Triggers that fire on user defined rules Both are stored in the database, and so, both could be called database triggers.
In Oracle Forms, you will find this point of view in the online ducumentation.

To my mind, only triggers of type 1 are database triggers, because type 2 is user defined.
The most simple example is a sequence trigger that fires on insert of a table.

Application triggers are user defined. They can be stored in the database, but they can also reside
on a clients application, e.g. Forms and Reports. These Oracle Tools have a number predefined templates of
triggers, firing on specific Tool events, and the triggers can be filled with user defined PL/SQL.

Hope this helps.

Jan.

"In Season" <pigsing_at_yahoo.com> schrieb im Newsbeitrag news:ahmbrj$3pp1_at_imsp212.netvigator.com...
> THX~ALL
> --
> --------------------------------------------------------------
> 春天的盛放 ,夏天的仲夜
> 秋天的童話 ,冬天的故事
> @切盡在不言中...........

(???)

> My ftp (upload only)
> ftp://upload:upload@inseason.no-ip.com
> --------------------------------------------------------------
>
>
Received on Wed Jul 24 2002 - 09:19:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US