Rajeshwaran

• Jun 3rd, 2006

 

usually the views are created from the basetable if only the basetable exists.

The purpose of FORCE keyword is to create a view if the underlying base table doesnot exists.

ex : create or replace FORCE view <viewname> as <query>

while using the above syntax to create a view the table used in the query statement doesnot necessary to exists in the database

RoulRaj

• May 9th, 2007

 

Dear Rajeswaran,
Please give one example(application) where one can use force view.
Thanks & regards