This discussion is archived
4 Replies Latest reply: Nov 13, 2012 12:46 PM by Osama_Mustafa RSS

Trigger

MLIPU Newbie
Currently Being Moderated
What is trigger. what is the use of trigger in oracle.
  • 1. Re: Trigger
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    A trigger is a named program unit that is stored in the database and fired (executed) in response to a specified event. The specified event is associated with either a table, a view, a schema, or the database, and it is one of the following:

    A database manipulation (DML) statement (DELETE, INSERT, or UPDATE)

    A database definition (DDL) statement (CREATE, ALTER, or DROP)

    A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN)

    The trigger is said to be defined on the table, view, schema, or database.

    Read
    http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm
  • 2. Re: Trigger
    sb92075 Guru
    Currently Being Moderated
    970953 wrote:
    What is trigger. what is the use of trigger in oracle.
    consider obtaining answer by actually Reading The Fine Manuals found at http://docs.oracle.com
  • 3. Re: Trigger
    Marco V. Expert
    Currently Being Moderated
    Have a look at these links.

    Wiki definition of Database Trigger:
    http://en.wikipedia.org/wiki/Database_trigger

    From Oracle Doc...
    ... Introduction to Triggers:
    http://docs.oracle.com/cd/B28359_01/server.111/b28318/triggers.htm#CNCPT118

    ... Overview of Data Integrity and Triggers
    http://docs.oracle.com/cd/B28359_01/server.111/b28318/intro.htm#CNCPT1012

    ... Triggers
    http://docs.oracle.com/cd/B28359_01/server.111/b28318/triggers.htm#CNCPT017
  • 4. Re: Trigger
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Please mark this thread as answered .

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points