关闭

Oracle基础学习笔记(四)(VIEW)

100人阅读 评论(0) 收藏 举报

CREATE [OR REPLACE] VIEW [{FORCE | NOFORCE}] view_name

AS subquery

[WITH {CHECK OPTION | READ ONLY} CONSTRAINT cons_name];

 

FORCE -- the view can be created even the base tables doesn't exist.

WITH CHECK OPTION -- only rows can be retrieved by the subquery can be inserted, updated or deleted

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:18664次
    • 积分:405
    • 等级:
    • 排名:千里之外
    • 原创:24篇
    • 转载:3篇
    • 译文:0篇
    • 评论:0条