ابدأ بالتواصل مع الأشخاص وتبادل معارفك المهنية

أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.

متابعة

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

user-image
تم إضافة السؤال من قبل Mohamed Saleh El-Sayed Elbatrawy , Digital Marketing Specialist , The Arab Academy for Science, Technology and Maritime Transport
تاريخ النشر: 2016/01/11
Usman Ajaz
من قبل 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
من قبل 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.

المزيد من الأسئلة المماثلة