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

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: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no way to know this.

Regards
Michel
Re: Trigger Information [message #349916 is a reply to message #349910] Tue, 23 September 2008 08:28 Go to previous message
namakkalsenthil
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: Sat Nov 02 05:02:05 CDT 2024