What is Mutating Table?

What is Mutating Table?

What is Mutating Table?

View Answers

November 15, 2010 at 4:25 PM

hi,

here is the answer,

Mutating Table is a table that is currently being modified by an Insert, Update or Delete statement. Constraining Table is a table that a triggering statement might need to read either directly for a SQL statement or indirectly for a declarative Referential Integrity constraints. Pseudo Columns behaves like a column in a table but are not actually stored in the table.

For example, if your trigger contains a select statement or an update statement referencing the table it is triggering off of you will receive the error.

Thanks,









Related Tutorials/Questions & Answers:
What is Mutating Table?
ModuleNotFoundError: No module named 'tableh'
Advertisements
ModuleNotFoundError: No module named 'tabler'
ModuleNotFoundError: No module named 'tabler'
what is the jsp coding to insert a data in database tables
ModuleNotFoundError: No module named 'django-tabler'
ModuleNotFoundError: No module named 'tablet'
Data fetch from multiple SQL tables - Hibernate
CSV tables
Nest tables within tables
tables for layout
tables for layout
SQL Server row comparison using two tables
merge tables in sql using union
Comparing tables
J query event for selecting the more than one div in tablet browser(Select and drag)?
Different tables present in MySQL
use tables to structure forms
use tables to structure forms
tables to structure forms
tables to structure forms
ModuleNotFoundError: No module named 'tables'
program to create nested tables
SQL All Tables
Join the two tables in sql
PL/SQL tables
Joining tables using criteria
Using criteria for multiple tables
Using criteria for multiple tables
types of relationships in tables
how to set the tables one is left and another one is right - JSP-Servlet
look up tables in java
Get the list of tables in Sybase
PHP Join Tables
tables in oracle 10g
What is a "join"?
Elite Zebra Tables
Mysql List Tables
Create Database and tables in MySQL
ModuleNotFoundError: No module named 'cache-tables'
ModuleNotFoundError: No module named 'obj-tables'
ModuleNotFoundError: No module named 'Periodic-Tables'
ModuleNotFoundError: No module named 'pypyrus-tables'
ModuleNotFoundError: No module named 'sheepdog-tables'
ModuleNotFoundError: No module named 'sheepdog-tables'
ModuleNotFoundError: No module named 'sqlite-tables'
ModuleNotFoundError: No module named 'ascii-tables'
ModuleNotFoundError: No module named 'cache-tables'
ModuleNotFoundError: No module named 'cli-tables'
ModuleNotFoundError: No module named 'correspondence-tables'

Ads