+1 vote
in Oracle by

Q. What is a database trigger in Oracle? How to create it?

1 Answer

0 votes
by

Ans is:- 

A database trigger is a stored PL/SQL block. Oracle database executes it automatically when certain conditions are satisfied. The stored PL/SQL block is connected to a table, a schema or a database. A trigger can be created using the CREATE TRIGGER clause. We can choose to enable or disable it using the ENABLE and DISABLE clauses of the ALTER TABLE or ALTER TRIGGER statement. This is the frequently asked Oracle Interview Questions in an interview.

Related questions

0 votes
asked Jul 29, 2020 in Oracle by Hodge
0 votes
asked May 11, 2020 in Oracle by JackTerrance
...