Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Is It Possible To Include An Insert Statement On The Same Table To Which The Trigger Is Assigned?
Home
PL/SQL
Is It Possible To Include An Insert Statement On The Same Table To Which The Trigger Is Assigned?
+1
vote
asked
Mar 18, 2021
in
PL/SQL
by
sharadyadav1986
Is It Possible To Include An Insert Statement On The Same Table To Which The Trigger Is Assigned?
#plsql-trigger
triggers
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Mar 18, 2021
by
sharadyadav1986
If an INSERT statement is used on the same table to which the trigger is associated, then this will give rise to a mutating table, as it is not possible to change the same table that is already in the process of being changed.
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
0
votes
Q: How Can The Performance Of A Trigger Be Improved?
asked
Mar 15, 2021
in
PL/SQL
by
Robindeniel
#plsql-trigger
trigger
trigger-performance
0
votes
Q: How Can Triggers Be Used For The Table Auditing?
asked
Mar 15, 2021
in
PL/SQL
by
Robindeniel
#plsql-trigger
table-audit
plsql-table
0
votes
Q: Explain what are Instead Of Triggers?
asked
Mar 15, 2021
in
PL/SQL
by
Robindeniel
triggers
plsql-triggers
plsql
0
votes
Q: Is It Possible To Create Startup Or Shutdown Trigger For On-schema?
asked
Mar 18, 2021
in
PL/SQL
by
sharadyadav1986
#trigger-shutdown
plsql-trigger
0
votes
Q: Is It Possible To Define An Exception Within A Trigger?
asked
Mar 18, 2021
in
PL/SQL
by
sharadyadav1986
#plsql-exception
plsql-trigger
0
votes
Q: How many types of triggers are supported by Azure Data Factory?
asked
Jun 12, 2022
in
Azure Data Factory
by
SakshiSharma
triggers
azure-data-factory
+1
vote
Q: What are the triggers? How many types of triggers are available?
asked
Jun 4, 2022
in
Xamarin Exordium
by
sharadyadav1986
triggers
0
votes
Q: Is It Possible To Combine Several Triggering Events Into One Trigger?
asked
Mar 15, 2021
in
PL/SQL
by
Robindeniel
#trigger-event
plsql-trigger
plsql
0
votes
Q: Explain what are The System Privileges That Are Required By A Schema Owner (user) To Create A Trigger On A Table?
asked
Mar 15, 2021
in
PL/SQL
by
Robindeniel
#system-privileges
plsql
schema-owner
0
votes
Q: Explain what Is The Value Of Sql%found Attribute After And Before An Insert Statement Is Executed?
asked
Mar 13, 2021
in
PL/SQL
by
rajeshsharma
#sql-fuond
insert-statement
plsql-statement
...