Home » SQL & PL/SQL » SQL & PL/SQL » Trigger Information
Trigger Information [message #349910] Tue, 23 September 2008 08:13 Go to next message
Messages: 13
Registered: November 2007
Junior Member

I have an Front end application. In backend database Few inserts operations are happening to a table t1. I would like to to know if the INSERT statments fired are excuted by explicit INSERT SQL statements or through an INSERT trigger. let me know how can I find this details.
Re: Trigger Information [message #349911 is a reply to message #349910] Tue, 23 September 2008 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to know this.

Re: Trigger Information [message #349916 is a reply to message #349910] Tue, 23 September 2008 08:28 Go to previous message
Messages: 4
Registered: September 2008
Junior Member
It may be get updated by insert statement written in the procedure or insert trigger.

trigger is basically used to invoke when certain conditions are met.

it depends on your table and constaints insisited on that table.

if your table has no constraints then that must be updated by using insert statement
Previous Topic: Inserting default value during insert
Next Topic: Display all the months between two dates
Goto Forum:

Current Time: Tue Oct 25 05:13:16 CDT 2016

Total time taken to generate the page: 0.09652 seconds