Re: I need to vent
Date: Mon, 7 Mar 2016 02:35:21 -0400
Message-ID: <CACH2EDKQvT2=XCE85m6jPcVE8eBMbnWjRZ8yT3RirMgePuxp=Q_at_mail.gmail.com>
Another thing to rant about perhaps is... does your environment ever archive anything? Or do they just all leave it in Oracle, requiring backups, etc. etc.
On Fri, Mar 4, 2016 at 4:20 AM, Norman Dunbar <oracle_at_dunbar-it.co.uk> wrote:
> Morning Mladen,
>
> On 03/03/16 20:54, Mladen Gogala wrote:
>
>> On 03/01/2016 11:17 AM, Norman Dunbar wrote:
>>
>>> In case anyone is wondering, it allows ANY value in column xx.
>>>
>> Of course it does, because the predicate X = NULL will never be false,
>> no matter what X is.
>>
>
> I know that! ;-) That's why I flagged up the script as "do not apply" for
> two reasons that popped up from the constraint creation:
>
> * They didn't know what they were actually doing;
> * They obviously had not tested it afterwards.
>
> Therefore, it's not being applied to my test system!
>
>
>
> Cheers,
> Norm.
>
> --
> Norman Dunbar
> Dunbar IT Consultants Ltd
>
> Registered address:
> 27a Lidget Hill
> Pudsey
> West Yorkshire
> United Kingdom
> LS28 7LG
>
> Company Number: 05132767
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- -- Patrice My profiles: [image: Facebook] <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image: LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image: Twitter] <http://www.twitter.com/PatriceBoivin> -- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 07 2016 - 07:35:21 CET