4 Replies Latest reply: Nov 13, 2012 2:46 PM by Osama_Mustafa RSS

    Trigger

    MLIPU
      What is trigger. what is the use of trigger in oracle.
        • 1. Re: Trigger
          Osama_Mustafa
          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
            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.
              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
                Please mark this thread as answered .