What Is The Purpose Of The Optional Argument [or Replace] In A Create

1.	What Is The Purpose Of The Optional Argument [or Replace] In A Create Trigger Command?
Answer» The optional ARGUMENT [OR REPLACE] in a CREATE TRIGGER command re-creates an EXISTING trigger. Using this option allows changing the definition of an existing trigger without having to DELETE it FIRST. The optional argument [OR REPLACE] in a CREATE TRIGGER command re-creates an existing trigger. Using this option allows changing the definition of an existing trigger without having to delete it first.

What Is The Purpose Of The Optional Argument [or Replace] In A Create Trigger Command?

Answer»

The optional ARGUMENT [OR REPLACE] in a CREATE TRIGGER command re-creates an EXISTING trigger. Using this option allows changing the definition of an existing trigger without having to DELETE it FIRST.

The optional argument [OR REPLACE] in a CREATE TRIGGER command re-creates an existing trigger. Using this option allows changing the definition of an existing trigger without having to delete it first.

Discussion

No Comment Found

Related InterviewSolutions

What Are The Three Basic Sections Of A Pl/sql Block?
State Some Features Or Programming Constructs Supported By Pl/sql.
Name Few Schema Objects That Can Be Created Using Pl/sql?
State Few Notable Characteristics Of Pl/sql.
What Does The Colon Sign (: ) Implies In The Following Statement? :deficit := Balance – Loan;
What Is The Purpose Of %type Data Type? Explain With Example.
What Is The Purpose Of %rowtype Data Type? Explain With Example.
What Is A Pl/sql Package?
What Are The Pl/sql Cursors?
What Is Returned By The Cursor Attribute Sql%rowcount?

What Is The Purpose Of The Optional Argument [or Replace] In A Create Trigger Command?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment