LENGTHC
Example
Section titled “Example”SELECT LENGTHC('Hello, World') FROM dual;Output
Section titled “Output”12Explanation
Section titled “Explanation”The LENGTHC function in the given SQL code returns the size of the string ‘Hello, World’. The size here, 12, is the number of characters in the string. This includes all alphabets, numbers, special characters, and spaces. The LENGTHC function in Oracle can be used to retrieve the length of a string in this way.