![]() The triggering_event is associated with either a table, a view, a schema, or the database, and it is one of these:ĭML statement (described in "About Data Manipulation Language (DML) Statements")ĭDL statement (described in "About Data Definition Language (DDL) Statements")ĭatabase operation ( SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN) ![]() If the trigger is in the enabled state, the triggering_event causes the database to execute the triggered_action if the trigger_restriction is either TRUE or omitted. A trigger can have the same name as another kind of object in the schema (for example, a table) however, Oracle recommends using a naming convention that avoids confusion. ![]() The trigger_name must be unique for triggers in the schema. A trigger is a PL/SQL unit that is stored in the database and (if it is in the enabled state) automatically executes ("fires") in response to a specified event.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |