Trigger updating same table oracle

Rated 3.83/5 based on 870 customer reviews

When we update that column (type is varchar2), the update is showing 1,972 rows updated (and we commit after the UPDATE). ” The response back to me was, “Oh, that explains it. We had ‘::= :new.fname

A constraint can apply either to new data only (like a trigger) or to both new and existing data.

Now, whenever possible, I will go very far out of my way to avoid a trigger.

I have two primary reasons for avoiding triggers: Hopefully the first reason to avoid triggers, the maintenance headache, is fairly easy to see.

Her skills include SQL infrastructure and database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS/SSIS packages, administrative and infrastructure tools development, reporting services and more.

PDF (US Ltr) - 37.5Mb PDF (A4) - 37.5Mb PDF (RPM) - 36.9Mb HTML Download (TGZ) - 10.2Mb HTML Download (Zip) - 10.2Mb HTML Download (RPM) - 8.9Mb Man Pages (TGZ) - 211.3Kb Man Pages (Zip) - 321.0Kb Info (Gzip) - 3.4Mb Info (Zip) - 3.4Mb My SQL Backup and Recovery My SQL Globalization My SQL Information Schema My SQL Installation Guide My SQL and Linux/Unix My SQL and OS X My SQL Partitioning My SQL Performance Schema My SQL Replication Using the My SQL Yum Repository My SQL Restrictions and Limitations Security in My SQL My SQL and Solaris Building My SQL from Source Starting and Stopping My SQL My SQL Tutorial My SQL and Windows My SQL NDB Cluster 7.5 This statement creates a new trigger.

Leave a Reply