Jul 29, 2020 in Oracle
Q:

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

1 Answer

0 votes
Jul 29, 2020

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.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
Jul 29, 2020 in Oracle
0 votes
May 11, 2020 in Oracle
...