Skip to Main Content

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 write logic in a row,check present column value &previous column

RamuJul 6 2010 — edited Jul 10 2010
Hey Friends,
How to write logic pl/sql function or procedure in my table PER_ALL_ASSIGNMENTS_F each person having there are number of records. now am check each row present column and previous column, if present column = previous column then result null , else present column != previous column then returns present column value. In this way am check each column, how to write logic , could you please tell me any body, this is agent Report..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2010
Added on Jul 6 2010
4 comments
1,155 views