FORCE option in VIEWS
972355Feb 22 2013 — edited Feb 22 2013Good Morning to Everyone ;
Once again i am starting new thread about [ VIEWS in Oracle].
MY REF_LINK : https://forums.oracle.com/forums/thread.jspa?threadID=2501984&start=0&tstart=0
I am trying to create view with FORCE option
SQL>create view force_view as
*2 select empid ,email from emps;*
select empid ,email from emps
*+
ERROR at line 2:
ORA-00942: table or view does not exist
NOTE : There is no table in the name of "emps"
What i learnt about FORCE OPTION :
*" Creating a view regardless (in any case) of whether or not the base tables exist "*
Oracle docs saying little different ( what i learnt )
Really not understandable from this link : "http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8004.htm"
Could anyone make little demo for force option ?
Thanks to Everyone !