Two Trigger of same type on same table which will get executed first?

I have a very basic doubt. Suppose we heve two after insert trigger TR1 and TR2 on table 1. One trigger updates same Table 1 and second trigger Call procedure .. I need TR1 to execute before TR2.. How this can be achieved.. Thanks

Answers


In Oracle 11G you can use the PRECEDES or FOLLOWS clauses e.g.

create trigger TR2
after insert on table1
for each row
follows TR1 -------------------------------------------------<<
begin
 ...
end;

Prior to 11G the order if firing was indeterminate; the only way to ensure correct execution was to combine the 2 triggers into 1.


Need Your Help

Better way to convert NSArray of NSNumbers to array of NSStrings

objective-c cocoa nsarray

I have an NSArray consisting of NSNumbers and I want to convert this to an NSArray of NSStrings, by getting the stringValue of each NSNumber in the first array.

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.