disable_enable.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 17 行

INSERT INTO plsql101_product VALUES (
     'Red Snaphoo', 1.95, 10, '30-12月-01')
;

ALTER TABLE plsql101_product DISABLE CONSTRAINT reasonable_stock_date;

INSERT INTO plsql101_product VALUES (
     'Red Snaphoo', 1.95, 10, '30-12月-01')
;

ALTER TABLE plsql101_product ENABLE CONSTRAINT reasonable_stock_date;

UPDATE plsql101_product 
SET    last_stock_date = '31-12月-01' 
WHERE  last_stock_date = '30-12月-01';

ALTER TABLE plsql101_product ENABLE CONSTRAINT reasonable_stock_date;