أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
I think you mean get the value from previous row then you need to LEAD Function in Sql
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.