| normal view and force view [message #217400] |
Fri, 02 February 2007 01:00  |
kanis
Messages: 61
Registered: November 2006
|
Member |
|
|
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 #217422 is a reply to message #217408] |
Fri, 02 February 2007 02:19  |
JRowbottom
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
