Disadvantages of trigger in oracle.

Disadvantages of trigger in Oracle.

Disadvantages of a trigger are as follows:

- Triggers can execute every time some field in database is updated. If a field is likely to be updated often, it is a system overhead.

- Viewing a trigger is difficult compared to tables, views stored procedures.

- It is not possible to track or debug triggers.

- They are not not compiled.

- The SELECT trigger is not support.

- The trigger may fail completely.

- The triggers can be disabled accidentally or dropped by a person.

- The versions cannot be controlled.

- The updation of a column cannot be done at once.

- The SYS table triggers do not support.

- They have mutating triggers.

- The triggers can have a hidden behaviour.
What is a NOCOPY parameter in oracle?
Apart from IN, OUT, IN OUT parameters, oracle 8i offers another parameter called NOCOPY.....
What is Raise_application_error in oracle?
Raise_application_error allows users to create custom error messages...
Difference between a View and Materialized View in oracle.
View is created joining a single or multiple tables. It is an abstract of the data distributed in different tables.....
Post your comment