SQL入門之9使用default

wmlm發表於2007-04-06
SQL
在DML 時顯式使用default示例[@more@]Specify DEFAULT to set the column to the value previously specified as the default value for the column. If no default value for the corresponding column has been specified, Oracle sets the column to null.
-- 示例
UPDATE departments
SET manager_id = DEFAULT WHERE department_id = 10;
INSERT INTO departments
(department_id, department_name, manager_id)
VALUES (300, 'Engineering', DEFAULT);

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/271063/viewspace-908948/，如需轉載，請註明出處，否則將追究法律責任。

相關文章