There are many very cool features in 11g which I am very eager to implement. However, I have previously attempted to migrate to the initial Oracle major release (8i, 9i, 10g) with some difficulty. Moving to the 'bleeding edge' usually resulted in lots of frustration and a feeling that I was one of Oracle's system testers. In my experience, Oracle usually has some major issues with their first attempt at anything more than a patchset.
Since I am feeling way too lazy today to do the research myself,
has anyone checked on the expected time frame for the second release of 11g?
-----Original Message-----
From: Jan Holst Jensen [mailto:oracledba-ezmlmshield-x54912433.[Email address protected]
Sent: Wednesday, March 05, 2008 3:53 AM
To: LazyDBA Discussion
Subject: Re: Specifying Trigger Firing Order
It probably does not help you much, but just for the record, it is
possible if you use 11g:
http://www.oracle-base.com/articles/11g/TriggerEnhancements_11gR1.php
Cheers
-- Jan Holst Jensen
Roger TEDMAN wrote:
> Trigger types fire in a set order but two 'before update' triggers for example will fire in no set order. If its important, write a procedure with both sets of code, and call it from a single trigger.
>
>
>
>
>
>> Message du 04/03/08 22:53
>> De : "Qi Cheng "
>> A : "LazyDBA Discussion"
>> Copie à :
>> Objet : Specifying Trigger Firing Order
>>
>> is there any way to specifying Trigger Firing Order?
>>
>>
>>
>> ---------------------------------------------------------------------
>> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>> To post a dba job: http://jobs.lazydba.com
>> To Subscribe : http://www.LazyDBA.com
>> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>>
>>
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
--
------------------------------------------------------------------------
jan-holst.dk
v/ Jan Holst Jensen
Lindegårdsvej 44, 2. TV Mobil 20 63 40 29
2920 Charlottenlund e-mail [Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
______________
The information contained in this message is proprietary and/or confidential. If you are not the
intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
please be aware that any message addressed to our domain is subject to archiving and review by
persons other than the intended recipient. Thank you.
_____________
Oracle LazyDBA home page