The views are created from the base table if only the base table exists. The FORCE keyword is used to create a view if the base table doesn’t exist.
Ex: create or replace FORCE view <view name> as <query>
While using the above syntax to create a view the table used in the query statement doesn’t necessary to exist in the database.
No comments:
Post a Comment