begin
select uc.CONSTRAINT_NAME into v_constraint from user_constraints uc,user_cons_columns ucc where
ucc.constraint_name=uc.constraint_name and
uc.table_name='YANG' and
ucc.column_name='BB' and
uc.constraint_type='U' and
substr(uc.CONSTRAINT_NAME,0,3)<>'SYS';execute immediate 'alter table YANG drop constraint '||v_constraint;end
select uc.CONSTRAINT_NAME into v_constraint from user_constraints uc,user_cons_columns ucc where
ucc.constraint_name=uc.constraint_name and
uc.table_name='YANG' and
ucc.column_name='BB' and
uc.constraint_type='U' and
substr(uc.CONSTRAINT_NAME,0,3)<>'SYS';execute immediate 'alter table YANG drop constraint '||v_constraint;end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货