lead function

LEAD and LAG Analytic Functions

June 3, 2020 by techgoeasy Leave a Comment

Lead function in oracle LEAD Function in Oracle is a Analytic function which has the ability to compute an expression on the next rows (rows which are going to come after the current row) and return the value to the current row. The general syntax of LEAD is shown below: LEAD (<expr>, <offset>, <default>) OVER […]