Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FORCE option in VIEWS

972355Feb 22 2013 — edited Feb 22 2013
Good 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 !
This post has been answered by BSalesRashid on Feb 22 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2013
Added on Feb 22 2013
16 comments
3,867 views