Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Can we do backward referencing in sql ? if possible then how?

PL SQL
user-image
Question added by Mohamed Saleh El-Sayed Elbatrawy , Digital Marketing Specialist , The Arab Academy for Science, Technology and Maritime Transport
Date Posted: 2016/01/11
Upvote (0) Views (2) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Usman Ajaz
by Usman Ajaz , TOS Administrator , DP World

I think you mean get the value from previous row then you need to LEAD Function in Sql 

Mohamed Saleh El-Sayed Elbatrawy
by Mohamed Saleh El-Sayed Elbatrawy , Digital Marketing Specialist , The Arab Academy for Science, Technology and Maritime Transport

Oracle strongly recommends that you run your database in automatic undo mode by setting the UNDO_MANAGEMENT initialization parameter to AUTO. In addition, set theUNDO_RETENTION initialization parameter to an interval large enough to include the oldest data you anticipate needing.

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help