Oracle Triggers ( All )

Oracle Triggers

Oracle’s triggers are used throughout the Oracle system as a

means of writing event-driven code.

Database triggers activate blocks of PL/SQL code

whenever the triggering event occurs in the database.

Likewise in Oracle Forms, triggers activate blocks of

PL/SQL code whenever a triggers event occurs on the

form.

Triggers are an important component of managing and

programming using Oracle.

Triggers can be created by writing appropriate SQL

statements. Triggers can also be created using the Forms

Developer tool set.

 

List of Oracle Database Triggers

AFTER ALTER

AFTER ANALYZE

AFTER ASSOCIATE STATISTICS

AFTER AUDIT

AFTER COMMENT

AFTER CREATE

AFTER DDL

AFTER DELETE

AFTER DISASSOCIATE STATISTICS

AFTER GRANT

AFTER INSERT

AFTER LOGON

AFTER NOAUDIT

AFTER RENAME

AFTER REVOKE

AFTER SERVERERROR

AFTER STARTUP

AFTER SUSPEND

AFTER TRUNCATE

AFTER UPDATE

BEFORE ALTER

BEFORE ANALYZE

BEFORE ASSOCIATE STATISTICS

BEFORE AUDIT

BEFORE COMMENT

BEFORE CREATE

BEFORE DDL

BEFORE DELETE

BEFORE DISASSOCIATE STATISTICS

BEFORE GRANT

BEFORE INSERT

BEFORE LOGOFF

BEFORE NOAUDIT

BEFORE RENAME

BEFORE REVOKE

BEFORE SHUTDOWN

BEFORE TRUNCATE

BEFORE UPDATE

INSTEAD OF DELETE

INSTEAD OF INSERT

INSTEAD OF UPDATE

Forms Developer Triggers

Delete-Procedure

Insert-Procedure

Key-Fn

Key-Others

Lock-Procedure

On-Check-Delete-

Master

On-Check-Unique

On-Clear-Details

On-Close

On-Column-Security

On-Commit

On-Count

On-Delete

On-Dispatch-Event

On-Error

On-Fetch

On-Insert

On-Lock

On-Logon

On-Logout

On-Message

On-Populate-Details

On-Rollback

On-Savepoint

On-Select

On-Sequence-

Number

On-Update

Post-Block

Post-Change

Post-Database-

Commit

Post-Delete

Post-Form

Post-Forms-Commit

Post-Insert

Post-Logon

Post-Logout

Post-Query

Post-Record

Post-Select

Post-Text-Item

Post-Update

Pre-Block

Pre-Commit

Pre-Delete

Pre-Form

Pre-Insert

Pre-Logon

Pre-Logout

Pre-Popup-Menu

Pre-Query

Pre-Record

Pre-Select

Pre-Text-Item

Pre-Update

Query-Procedure

Update-Procedure

When-Button-

Pressed

When-Checkbox-

Changed

When-Clear-Block

When-Create-Record

When-Custom-Item-

Event

When-Database-

Record

When-Form-

Navigate

When-Image-

Activated

When-Image-Pressed

When-List-Activated

When-List-Changed

When-Mouse-Click

When-Mouse-

DoubleClick

When-Mouse-Down

When-Mouse-Enter

When-Mouse-Leave

When-Mouse-Move

When-Mouse-Up

When-New-Block-

Instance

When-New-Form-

Instance

When-New-Item-

Instance

When-New-Record-

Instance

When-Radio-

Changed

When-Remove-

Record

When-Tab-Page-

Changed

When-Timer-Expired

When-Validate-Item

When-Validate-

Record

When-Window-

Activated

When-Window-

Closed

When-Window-

Deactivated

When-Window-

Resized

Advertisements

About Oracle Technology Blogs
Oracle Application Development

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: