in Oracle by

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

► Click here to show 1 Answer

0 votes

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.

Learn More with Madanswer

Related questions

0 votes
asked Jul 29, 2020 in Oracle by Hodge