本文共 935 字，大约阅读时间需要 3 分钟。

Oracle ?????CREATE VIEW????????????????????????????????????? Oracle ??CREATE VIEW ?????????????????????

????

CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view_name[(alias[, alias]...)]AS subquery[WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY]

??????

????

??

-- ???? `user_view` ?????? `users` ?CREATE VIEW user_view AS SELECT * FROM users;-- ???? `sales_analyst_view` ?????? `sales` ??????? `sa`CREATE VIEW sales_analyst_view AS SELECT * FROM sales WHERE department = 'SA' AS sa;

????

• FORCE ? NOFORCE??????????NOFORCE ????????????????
• WITH CHECK OPTION????????????????????????
• WITH READ ONLY???????????????????

?????? Oracle CREATE VIEW ????????????????????????????????????