INSERT using WITH CHECK OPTION
来源:互联网 发布:淘宝店延长收货是几天 编辑:程序博客网 时间:2024/04/28 18:54
--The following statement is legal even though
-- the third value inserted violates the condition
-- of the subquery where_clause:
INSERT INTO (SELECT department_id, department_name, location_id
FROM departments WHERE location_id < 2000)
VALUES (9999, 'Entertainment', 2500);
-- However, the following statement is illegal because it contains
-- the WITH CHECK OPTION clause:
INSERT INTO (SELECT department_id, department_name, location_id
FROM departments WHERE location_id < 2000 WITH CHECK OPTION)
VALUES (9999, 'Entertainment', 2500);
*
ERROR at line 2:
ORA-01402: VIEW WITH CHECK OPTION where-clause violation
可以把那个子查询看成一个视图或者表,insert into table_name(or subquery) values();
- INSERT using WITH CHECK OPTION
- Oracle INSERT WITH CHECK OPTION的用法
- OCP-047insert into subquery with check option values()
- WITH CHECK OPTION用法
- with check option
- 视图 WITH CHECK OPTION
- with check option
- with check option
- with check option
- with check option
- 浅析 with check option
- with check option
- WITH CHECK OPTION
- with check option使用
- with check option
- with check option
- with check option和with grant option
- 关于Oracle Insert 语句的子查询 和 with check option的用法
- 收藏:《UTF-8与GB2312之间的互换》的改进
- to_char的用法
- Error connecting to server localhost on port 1527 with message Connection refused
- IKEv2-3
- jquery常用方法一览
- INSERT using WITH CHECK OPTION
- external table
- char数组转换成byte数组
- 读书笔记《c语言深度解剖》(5)
- 8个实用ASP.NET工具助你开发更高效
- 键盘上每个键作用!!! (史上最全的)
- 伯埙仲篪
- 感慨一下,OI & ACM
- Windows Server 2003下安装IIS