Skip to content

LENGTH2

SELECT LENGTH2('Oracle SQL') AS String_Length FROM dual;
String_Length
-------------
10

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.