Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
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.