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:
DDL | DML |
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. |