Home » SQL & PL/SQL » SQL & PL/SQL » FORCE VIEW
FORCE VIEW [message #248930] Mon, 02 July 2007 14:26 Go to next message
anreddy
Messages: 3
Registered: July 2007
Location: banglore
Junior Member
HI,
thIS IS ANREDDY,NEW TO THIS FORUM,
WHY WE USE FORCE VIEW?PLS LET ME KNOW ABOUT THIS..
DONT GIVE ME DEFENATION OF FORCE VIEW...
Re: FORCE VIEW [message #248931 is a reply to message #248930] Mon, 02 July 2007 14:39 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Your shift key appears stuck.
Are you new to GOOGLE too?
Re: FORCE VIEW [message #248932 is a reply to message #248930] Mon, 02 July 2007 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you want to create an invalid view that may be validated in the future.
Almost only import utility uses this.

Regards
Michel
Re: FORCE VIEW [message #248964 is a reply to message #248932] Mon, 02 July 2007 23:51 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Michel Cadot wrote on Mon, 02 July 2007 21:41
Almost only import utility uses this.



Not quite true.
It can very well be used in installation scripts if you don't want to be bothered by the order in which to create objects.

Since views are the only objects (from the top of my head) that don't get created if they'd be invalid, it would be necessary to create them in exactly the right order during installation.
If your installation strategy contains collect-scripts per objecttype (e.g. first create all tables using tab.sql, then all packages using pks.sql etc) it could be that you would need more than one view script.
If you use 'force' during the creation of views, this is not necessary.
Re: FORCE VIEW [message #249010 is a reply to message #248964] Tue, 03 July 2007 01:30 Go to previous message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

You need a view for a table that does not exists but may exist in the future.In that scenario ,You will go for a forced view.
Previous Topic: question on views
Next Topic: outer join
Goto Forum:
  


Current Time: Thu Dec 08 10:19:43 CST 2016

Total time taken to generate the page: 0.06533 seconds