Re: NOT NULL constrinat lost in VIEW after cast

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.
>
> any help on my little problem would be very appreciated,
> AndiZed

Oracle version?
DDL? We can not look over your shoulder and see your monitor.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org