Oracle: Stored Procedures and triggers

Stored procedure (stored procedure): can be regarded as the name of the PL/SQL program block, by name call execution; can take parameters or without parameters.

Trigger (Trigger): Event-triggered execution, which can be considered a special type of stored procedure.

An ACC stored procedure is established that shows the account ID and its corresponding money value:

Stored procedure execution: 1.exec p; 2. Begin

P

End

/

The following stored procedure adds 1 revenue to users earning revenue in the [1000,2000] zone, and adds 2 revenue to users earning in the [2000,3000] interval.

Display after execution:

Trigger:

Two examples: 1. Create an action Log 2. Modify the foreign Key Association of the database

1. Create an action log:

Create trigger: Before/after Insert or Deleteor update on account (multiple triggering events can be separated by or)

Perform an action to see if the Acclog table is automatically counted

Oracle: Stored Procedures and triggers