LENGTH4
Example
Section titled “Example”SELECT LENGTH4('Oracle') AS "Length4"FROM dual;Output
Section titled “Output”Length4-------6Explanation
Section titled “Explanation”The LENGTH4 function in Oracle SQL returns the length of a string, measuring it in characters, rather than bytes. The function returns 6, indicating that the string ‘Oracle’ consists of 6 characters.
Example
Section titled “Example”SELECT LENGTH('SQL SERVER') AS LENGTH;Output
Section titled “Output”7Explanation
Section titled “Explanation”The LENGTH function in SQL Server is used to return the number of characters in a specified string. In the provided example, the LENGTH function returns the number of characters in the string ‘SQL SERVER’, which is 7.