在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);
-- 示例
UPDATE departments
SET manager_id = DEFAULT WHERE department_id = 10;
INSERT INTO departments
(department_id, department_name, manager_id)
VALUES (300, 'Engineering', DEFAULT);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/271063/viewspace-908948/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQL入门之8 限制插入数据的范围
下一篇：
SQL入门之10 MERGE
请登录后发表评论
登录
全部评论
