LN is one of the vital Numeric/Math functions of Oracle. It is used to get the natural logarithm of a number. The LN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LN( number ) Parameters: number: It is used to … Read more
LISTAGG is one of the vital Analytic functions of Oracle. It is used to concatenates values of a column for each GROUP. The LISTAGG function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c and Oracle 11g Release 2. Syntax: LISTAGG (measure_column, ‘delimiter’) WITHIN GROUP (order_by_clause) [OVER (query_partition_clause)] Parameters: measure_column: It is … Read more
LENGTHC is one of the vital string/char functions of Oracle. It is used to get the length of a string, same as the LENGTHB function with the only difference that it uses the UNICODE complete characters. The LENGTHC function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, … Read more
LENGTHB is one of the vital string/char functions of Oracle. It is used to get the length of a string, same as the LENGTH4 function with the only difference that it uses the bytes instead of characters. The LENGTHB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle … Read more
LENGTH4 is one of the vital string/char functions of Oracle. It is used to get the length of a string, same as the LENGTH and the LENGTH2 functions with the only difference that it uses the UCS4 code points. The LENGTH4 function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle … Read more
LEAD is one of the vital Analytic functions of Oracle. It is used to query more than one row in a table at a time. With the use of LEAD function there is no need to join the table to itself. The result is the values from the next row in the table. The LEAD … Read more
LAST_VALUE is one of the vital Analytic functions of Oracle. It is used to get the last value in an ordered set of values from an analytic window. The LAST_VALUE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax 1: LAST_VALUE (expression) [RESPECT … Read more
LAG is one of the vital Analytic functions of Oracle. It is used to query more than one row in a table at a time. With the use of LAG function there is no need to join the table to itself. The result is the values from a previous row in the table. The LAG … Read more
INSTRC is one of the vital string/char functions of Oracle. It is used to get the location of a substring, where a substring is a part of a string. It works same as INSTRB function with the only difference that it uses UNICODE complete characters. The INSTRC function is supported in the various versions of … Read more
INSTRB is one of the vital string/char functions of Oracle. It is used to get the location of a substring, where a substring is a part of a string. It works same as INSTR4 function with the only difference that it uses bytes instead of characters. The INSTRB function is supported in the various versions … Read more