Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Mohamed Saleh El-Sayed Elbatrawy , Digital Marketing Specialist , The Arab Academy for Science, Technology and Maritime Transport
Date de publication: 2016/01/11
Usman Ajaz
par 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
par 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.

More Questions Like This