LENGTH2

Oracle

LENGTH2(string)

• string: The string whose length is returned.

Example

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

Output

String_Length
-------------
10

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.