Home » SQL & PL/SQL » SQL & PL/SQL » what is BYPASS_UJVC? in update statement
what is BYPASS_UJVC? in update statement [message #342814] Mon, 25 August 2008 03:53 Go to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
Hi all,
Someone has used this in update statement and when this query is executed it is giving error. What is this about?
what is the possible danger of using *+ BYPASS_UJVC*/ ?
Re: what is BYPASS_UJVC? in update statement [message #342818 is a reply to message #342814] Mon, 25 August 2008 04:08 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
Read this link. Hopefully you will be understand what is BYPASS_UJVC is ?

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1197999096334

Regards

Raj
Re: what is BYPASS_UJVC? in update statement [message #342819 is a reply to message #342814] Mon, 25 August 2008 04:12 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not documented, so dangerous.
Use MERGE instead.

Regards
Michel
Previous Topic: Complex Query
Next Topic: Date conversation issue
Goto Forum:
  


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

Total time taken to generate the page: 0.11046 seconds