CODE EXAMPLE FOR SQL

varchar2 length in oracle

SELECT LENGTH('CANDIDE') "Length in characters"
   FROM DUAL;