oracledba管理腳本-資料下載頁
2025-04-07 06:22本頁面
【正文】 SIZE 0SET FEEDBACK OFFSET VERIFY OFFSPOOL SELECT 39。ALTER TABLE 39。 || || 39。 ENABLE PRIMARY KEY。39。FROM all_constraints aWHERE = 39。P39。AND = Upper(39。amp。239。)AND = DECODE(Upper(39。amp。139。),39。ALL39。,Upper(39。amp。139。))。SPOOL OFF Comment out following line to prevent immediate run@SET PAGESIZE 14SET FEEDBACK ONSET VERIFY ON 8. 啟用參考性外鍵 File Name : Author : DR Timothy S Hall Description : Enables all Foreign Keys referencing a specified table, or all tables. Call Syntax : @enable_ref_fk (tablename) (schemaname) Last Modified: 28/01/2001 SET PAGESIZE 0SET FEEDBACK OFFSET VERIFY OFFSPOOL SELECT 39。ALTER TABLE 39。 || || 39。 ENABLE CONSTRAINT 39。 || || 39。39。FROM all_constraints aWHERE = Upper(39。amp。239。)AND = 39。R39。AND IN (SELECT FROM all_constraints a1 WHERE = DECODE(Upper(39。amp。139。),39。ALL39。,Upper(39。amp。139。)) AND = Upper(39。amp。239。))。SPOOL OFF Comment out following line to prevent immediate run@SET PAGESIZE 14SET FEEDBACK ONSET VERIFY ON9 / 9
公司管理相關(guān)推薦
鄂ICP備17016276號-1