Home » SQL & PL/SQL » SQL & PL/SQL » update issue (xp)
update issue [message #361699] Thu, 27 November 2008 10:34 Go to next message
keizersoz
Messages: 16
Registered: April 2006
Junior Member
Hi,

In oracle 10 while trying to execute the following conditional update the application hangs

BEGIN
UPDATE
  RIGHTS
SET 
  LEVEL2=DECODE(LEVEL2,'Def','Conf','Reg','Test')
WHERE
 LEVEL1='Activ';
END;
/


Is there a problem in the fact that I use the set variable in the decode statement?

many thanks

[Updated on: Thu, 27 November 2008 10:36]

Report message to a moderator

Re: update issue [message #361703 is a reply to message #361699] Thu, 27 November 2008 11:19 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
What do you mean by it hangs ? Or how do you know it hangs . Check the explain of the query. Also check the v$session_wait for what it is doing.

Regards

Raj

[Updated on: Thu, 27 November 2008 11:21]

Report message to a moderator

Re: update issue [message #361706 is a reply to message #361699] Thu, 27 November 2008 11:25 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And check v$lock and dba_blockers.

Regards
Michel
Previous Topic: How to create Sequence generating alpha numeric values
Next Topic: DBMS_JOB
Goto Forum:
  


Current Time: Sat Dec 03 22:24:25 CST 2016

Total time taken to generate the page: 0.13172 seconds