19c OCP 加入小组

28个成员 37个话题 创建时间:2021-01-15

请问老师A为什么是正确的?

发表于2021-01-27 2463次查看

1回复
  • 2楼 崔旭老师 2021-01-28

    视图就是可以先创建,不管基表的。

    请参考force选项。

    FORCE

    Specify FORCE if you want to create the view regardless of whether the base tables of the view or the referenced object types exist or the owner of the schema containing the view has privileges on them. These conditions must be true before any SELECTINSERTUPDATE, or DELETE statements can be issued against the view.

发表回复
你还没有登录,请先 登录或 注册!