Re: updation order of fields in a table
Posted by:
rook deis
Date: June 22, 2012 04:07AM
Hello Thanks.Yes the logic is bit different. i want the diff of two values. if diff is positive put in AmtDR else in AmtCR.
It is a one time process.
Yes the data was supposed to be correctly inserted. This occurs due to an error in my app. so i am running a process till the bug is found :)
As i have to do this for a number of records i cannot use a variable. so i run the query update twice; one for positive values and one for negative values .now it works fine.
thanks
Edited 1 time(s). Last edit at 06/22/2012 04:08AM by rook deis.
Subject
Views
Written By
Posted
1397
June 20, 2012 10:26PM
1018
June 21, 2012 07:59PM
Re: updation order of fields in a table
1151
June 22, 2012 04:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.