?? disable_chk.sql
字號:
--* File Name : Disable_Chk.sql
--* Author : DR Timothy S Hall
--* Description : Disables all check constraints for a specified table, or all tables.
--* Call Syntax : @Disable_Chk (table-name or all) (schema-name)
--* Last Modified: 28/01/2001
SET PAGESIZE 0
SET FEEDBACK OFF
SET VERIFY OFF
SPOOL temp.sql
SELECT 'ALTER TABLE ' || a.table_name || ' DISABLE CONSTRAINT ' || a.constraint_name || ';'
FROM all_constraints a
WHERE a.constraint_type = 'C'
AND a.owner = Upper('&2');
AND a.table_name = DECODE(Upper('&1'),'ALL',a.table_name,UPPER('&1'));
SPOOL OFF
-- Comment out following line to prevent immediate run
@temp.sql
SET PAGESIZE 14
SET FEEDBACK ON
SET VERIFY ON
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -