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

INSTR4 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 INSTR and the INSTR2 function with the only difference that it uses UCS4 code points. The INSTR4 function is supported in the … Read more

LENGTH2 is one of the vital string/char functions of Oracle. It is used to get the length of a string, same as the LENGTH function with the only difference that it uses the UCS2 code points. The LENGTH2 function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, … Read more