Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL LEAD Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: LEAD

Definition:
The Oracle PL/SQL LEAD function is an analytic function through which one can access the succeeding or following row without making any self join. It is normally used to get the value of an attribute of the previous row. Until unspecified, LEAD can access one offset row after to the current cursor position.

(If you need to retrieve a value from the previous row, use LAG instead of LEAD.)

Example Syntax:

LEAD (value_expression [,offset] [,default]) OVER ([query_partition_clase] order_by_clause)


The default value is returned in case the offset moves the cursor position beyond the scope of the result set. It is NULL by default.

Example Usage:

SELECT EMPNO, ENAME, SALARY,
LEAD(SALARY, 1, 0) OVER (ORDER BY SALARY) AS NEXT_SAL,
FROM EMPLOYEES;



Related Links:

Related Code Snippets:
  • LEAD - LEAD provides access to a row at a given physical offset beyond that position.
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 213 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?