"Lead and lag oracle functionality"

I need to implement oracle Lead and Lag functions. Basically I want to check the values in the previous and next row and use them in if else statements.

Anyone has ideas for doing the same.

Help is greatly appreciated.

Thanks