pando:

You mean I can do like this:

CREATE OR REPLACE TRIGGER {trigger name}
AFTER INSERT OR DELETE OR UPDATE ON {table name}

DECLARE
pragma AUTONOMOUS_TRANSACTION;
dmlnumber number;
BEGIN
SELECT col1 INTO dmlnumber FROM stat_dml WHERE col2 = {table name};
dmlnumber = dmlnumber + 1;
UPDATE stat_dml SET col1 = :dmlnumber WHERE col2 = {table name};
COMMIT;
END {trigger name};