in Oracle by
Q:

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.

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

Related questions

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