Home » SQL & PL/SQL » SQL & PL/SQL » normal view and force view
normal view and force view [message #217400] Fri, 02 February 2007 01:00 Go to next message
Messages: 61
Registered: November 2006
I want to know the functional difference between normal view and force view.
Also want to know merits & demerits of force view??
Can anybody help me.
Re: normal view and force view [message #217408 is a reply to message #217400] Fri, 02 February 2007 01:29 Go to previous messageGo to next message
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Did you check the reference for this? And what is the question remaining?

Re: normal view and force view [message #217422 is a reply to message #217408] Fri, 02 February 2007 02:19 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
As the link @skooman pointed to says, the difference that FORCE makes is that it will create an invalid view rather than failing to create a view at all, if some of the objects that the view depends on do not exist.
I find this useful for creating release scripts - We have a lot of views that use user-defined functions, and frequently these functions are defined in packages that reference the views in question. This way you can run the sql to create the tables and views, and guarantee that these objects exist, which then lets you compile the packages that the views depend on into the database.
Previous Topic: Creation of materialized view
Next Topic: rollback to savepoint
Goto Forum:

Current Time: Mon Jul 24 16:19:32 CDT 2017

Total time taken to generate the page: 0.11696 seconds