LENGTH2
Example
Section titled “Example”SELECT LENGTH2('Oracle SQL') AS String_Length FROM dual;Output
Section titled “Output”String_Length-------------10Explanation
Section titled “Explanation”The LENGTH2 function in Oracle SQL returns the number of bytes in a given string. In the provided example, ‘Oracle SQL’ consists of 10 bytes, thus, the output is 10.