Hi gurus





create or replace type tab_rec as table of number not null;



type created



create table test(t tab_rec)nested table t store as tab_h;



table created



insert into test values(tab_rec(1,2,null));



the reason to it is taking null values



I want impose not null condition on table test on column t



How can do that









Thanks & Regards



V.Rajavardhan Reddy

Software Engineer

GSS America Infotech Ltd.

Block B, 3'rd Floor,

Cyber Gateway,

Hi-Tech City,

Hyderabad.

Tel:- 040-40028700

Fax:- 040-40028703

Visit us: http://www.gssamerica.com




Oracle LazyDBA home page