Length – Oracle SQL Function

LENGTH returns an integer that is the length of the 1st argument.

The 1st argument can be a CHAR, VARCHAR2,NCHAR,NVARCHAR2,CLOB or NCLOB datatype.

Example:

SELECT LENGTH(‘How long is this?’) as RESULT FROM DUAL;

RESULT
—————-
17