oracle
iteye_8134
这个作者很懒,什么都没留下…
展开
-
oracle_(query)export_sequence.sql
select 'create sequence '||sequence_name|| ' minvalue '||min_value|| ' maxvalue '||max_value|| ' start with '||last_number|| ' increment by '||increment_by|| (case when c...原创 2009-01-19 15:02:29 · 91 阅读 · 0 评论 -
oracle禁启用外键和触发器
-----启用外键和触发器--BEGINfor c in (select 'ALTER TABLE '||TABLE_NAME||' ENABLE CONSTRAINT '||constraint_name||' ' as v_sql from user_constraints where CONSTRAINT_TYPE='R') loopbegin EXECUTE IMMEDIATE c.v_s...2009-01-19 15:05:40 · 94 阅读 · 0 评论