Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: NOT NULL constrinat lost in VIEW after cast
On 22.05.2007 10:30 andized_at_gmx.net wrote:
> Hello,
>
> i am using a table with a varchar2 column that is specified NOT NULL
> and created a view to that table wich casts this column to NUMBER(10)
> using the cast() function. After performing a DESC on that table i
> realized, that the NOT NULL constraint of the table was lost in the
> view.
> the customer demands this NOT NULL constraint, to be sure the
> information he receives from the view is valid, but i dont know why
> oracle removed it and how i can apply it on a view.
>
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 Received on Wed May 23 2007 - 01:40:23 CDT