Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NOT NULL constrinat lost in VIEW after cast

Re: NOT NULL constrinat lost in VIEW after cast

From: Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com>
Date: Wed, 23 May 2007 11:14:16 +0200
Message-ID: <5biev8F2rp3aaU1@mid.individual.net>


On 23.05.2007 10:12 andized_at_gmx.net wrote:
> On 23 Mai, 08:40, Thomas Kellerer <JUAXQOSZF..._at_spammotel.com> wrote:

>> [...]
>>
>> I don't see the problem.
>> As long as the view is not updatable it doesn't matter whether the
>> column is NOT NULL.
>>
>> Thomas

>
> its not really a problem for me, but for the customer. if the customer
> can see the NOT NULL constraint, he can be sure that he will be
> receiving no NULL values for that column, which could cause failures
> in his processes.

I understand that it is your customer, but still: a VIEW does not have constraints. This is like saying "I cannot see the NOT NULL constraint when SELECTing from that table" Received on Wed May 23 2007 - 04:14:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US