Home » SQL & PL/SQL » SQL & PL/SQL » locks
locks [message #258563] Mon, 13 August 2007 01:32 Go to next message
Messages: 98
Registered: July 2007
Location: pune
Am running two jobs called job1 and job2

job1 updating data's on a table

job2 retrieving the data from a table.

While retrieving the data i need older value not an update value.

for ex old value in the table as 1000 and update values as 2000
i need 1000 as o/p while running the job2 .

So, what kind of lock i have to use and how to implement ?
Re: locks [message #258568 is a reply to message #258563] Mon, 13 August 2007 01:49 Go to previous messageGo to next message
Messages: 7880
Registered: March 2000
Senior Member
Simple: don't use intermittent commits in job1. Or start job2 prior to job1
Re: locks [message #258715 is a reply to message #258563] Mon, 13 August 2007 07:50 Go to previous message
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Or call job2 at the end of job1 before your commit
Previous Topic: Materialised view and database view
Next Topic: Oracle SQL error
Goto Forum:

Current Time: Sat Aug 19 23:08:46 CDT 2017

Total time taken to generate the page: 0.40696 seconds