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!

How to get the prior value of user entered value?

634151Aug 15 2009 — edited Aug 15 2009

Hi,

I have a query which will fetch the record like below.

NAME            CALC_VALUE
A                    10
B                    20
C                    30
D                    40
E                    50
F                    60
G                    70
H                    80
I                     90

I have a procedure which is having one input parameter. If My input value is 60 means, how can i get the prior value of this 60 from my above query result set. For example the prior value of 60 is 50.

Thanks

Edited by: orasuriya on Aug 15, 2009 10:44 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 12 2009

Added on Aug 15 2009

#oracle, #plsql, #sql

4 comments

696 views