Home » SQL & PL/SQL » SQL & PL/SQL » Force View
Force View [message #227746] Thu, 29 March 2007 04:51 Go to next message
nitin_kumat
Messages: 1
Registered: March 2007
Location: Nasik
Junior Member
What is force View? What is use of force view in oracle? Why Oracle give facility to create force view?
Re: Force View [message #227750 is a reply to message #227746] Thu, 29 March 2007 04:59 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Reported
Reported By: nitin_kumat
On: Thu, 29 March 2007 11:54
In: SQL & PL/SQL PL/SQL Experts Force View
Reason To Know about force viewp

Reporting messages is a way to let the moderators know that a certain post/thread is offending (violating copyrights, using strong language, ...) but not a way to get attention. Most users don't see reports.

Moved to newbies.

MHE
Re: Force View [message #227752 is a reply to message #227746] Thu, 29 March 2007 05:02 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
nitin_kumat wrote on Thu, 29 March 2007 11:51
What is force View? What is use of force view in oracle?

from the Oracle Database SQL Reference
Specify FORCE if you want to create the view regardless of whether the base tables of the view or the referenced object types exist or the owner of the schema containing the view has privileges on them. These conditions must be true before any SELECT, INSERT, UPDATE, or DELETE statements can be issued against the view.

If the view definition contains any constraints, CREATE VIEW ... FORCE will fail if the base table does not exist or the referenced object type does not exist. CREATE VIEW ... FORCE will also fail if the view definition names a constraint that does not exist.
nitin_kumat wrote on Thu, 29 March 2007 11:51
Why Oracle give facility to create force view?

See quote above.

MHE
Previous Topic: Multiple fields with allongside COUNT
Next Topic: Select Statement suddenly takes very long!
Goto Forum:
  


Current Time: Sat Dec 03 20:18:03 CST 2016

Total time taken to generate the page: 0.11142 seconds