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

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.