Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

how to use FIRST_VALUE function in oracle sql

FIRST_VALUE Function with PARTITION BY Clause in Oracle SQL – PLSQL

by

The FIRST_VALUE Function in Oracle SQL / PLSQL is an analytical function and is used to return the first value in an ordered set of values. If the first value in the ordered set is NULL, then FIRST_VALUE function returns NULL unless we specify IGNORE NULLS. If we specify IGNORE NULLS then, FIRST_VALUE function returns […]

FIRST_VALUE Function without PARTITION BY Clause in Oracle SQL – PLSQL

by

The FIRST_VALUE Function in Oracle SQL / PLSQL is an analytical function and is used to return the first value in an ordered set of values. If the first value in the ordered set is NULL then, FIRST_VALUE function returns NULL unless we specify IGNORE NULLS. If we specify IGNORE NULLS then, FIRST_VALUE function returns […]