I tried to create table from subquery that involves join operation. the tables:
create table t1(
col1 number
,col2 number
,col3 varchar2(50) not null
,constraint ck check(col2>col1)
)
create table t2(
col1 number
,col2 number
,col3 varchar2(100) not null
,constraint ck1 check(col2l>100)
)
create table composite as select * from t1 left join t2 using(col1,col2)
I checked the constraints formed in table composite and only the attribute level constraint in t1.col3 is copied. what about the other constraints? are they excluded since they're table-level constraint? thanks
Edited by: 801264 on Nov 27, 2010 4:07 AM