Force view
654617Oct 16 2008 — edited Oct 16 2008Hello Guys,
Can you tell me what is the use of view when we create with FORCE option if underliying table is not available ?
CREATE OR REPLACE FORCE VIEW MY_VIEW AS SELECT * FROM EMP;
Now View My_View will be created even if the emp table is not available. But where we can use this view ?. What is the applicatin of My_View when we know that EMP table is not available ?.
Thanking you.