pl sql trigger example

first, what is PL/SQLPL/SQL is an extension of the language. The SQL language is a non-procedural language in which the user simply tells the computer what to do without needing to understand how the computer is doing it. For example, users want to query a table of a column of data, only need to input:selectcolunm_name

Handling */END; The execution part is required.PL/SQL blocks can be divided into three types:1. Unknown block: it is a dynamic structure and can only be executed once.2. Subroutine: stored procedures, functions, and packages in the database. After the database is established, you can call them in other programs.3. Trigger: When a database operation occurs, some events are triggered to automatically execute

record. SQL code Create or replace procedure sp_pro2 is Begin -- execution part Delete from mytest where name = 'Han shunping '; End; Createor replace procedure sp_pro2 is Begin -- execution part Deletefrom mytest where name = 'Han shunping '; End; PL/SQL Introduction Introduction When developers use PL/

Chapter 2 procedural performance tuning of PL/SQL applications I. Reasons for PL/SQL Performance problems When the execution efficiency of PL/SQL-based applications is low, it is usually caused by poor

optional, indicating the maximum length that the string can store. Declaration of variables in PL/SQL is not the same as that in other languages. It is declared from right to left. For example, to declare a variable v_id of the number type, the form should be: V_id number; If you assign values to the above v_id variable, you cannot use

SQL Server DDL triggers (Trigger)-Create a server-level DDL triggerIf you create a server-level DDL trigger, you can track server-level events by changing the previous on database to the on all server, using the same principle as the DDL triggers at the DB level, which differ only in the events that are tracked.CREATE TRIGGER