NOT NULL constrinat lost in VIEW after cast

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 Received on Tue May 22 2007 - 03:30:31 CDT