Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

updating row data with previous or next row values

916675May 25 2012 — edited May 25 2012
Hi friends

I have a problem to update bad values with previous or next row


NAME DATETIME VAL

abc 05/25/2012 13:20 100
abc 05/25/2012 13:25 200
abc 05/25/2012 13:30 -32678 (BAD VALUE)
abc 05/25/2012 13:35 600
XYZ 05/25/2012 13:20 130
XYZ 05/25/2012 13:25 -32678 (BAD VALUE)
XYZ 05/25/2012 13:30 120
XYZ 05/25/2012 13:35 600


In the above example

I got negative value -32768 instead of that I want to place the next or previous value (200,600)

Here one condition is there DATETIME attribute is STRING data type

Edited by: 913672 on May 25, 2012 12:58 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2012
Added on May 25 2012
#update
10 comments
3,229 views