Oracle SQL,PL/SQL

What is DML and DDL trigger in PL/SQL?

Written by shohal

DML Trigger:

TRIGGERS are stored programs that are fired by Oracle engine automatically when DML Statements like insert, update, delete are executed on the table or some events occur. The code to be excecuted in case of a trigger can be defined as per the requirement.

DDL Trigger:

DDL triggers are the triggers which are created over DDL statements such as CREATE, DROP or ALTER.

Difference between DDL and DML in PL SQL:

DDLDML
Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.BASIC command present in DML are UPDATE, INSERT, MERGE etc.
DDL does not use WHERE clause in its statement.While DML uses WHERE clause in its statement.
It stands for Data Definition Language.It stands for Data Manipulation Language.
DDL does not use WHERE clause in its statement.While DML uses WHERE clause in its statement.

About the author

shohal

Leave a Comment