[Oracle] Oracle check string length

using LENGTH() function

sql :

SELECT LENGTH('abc') FROM DUAL;

Result:

LENGTH('abc')

--------------------

3

Reference:

https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions076.htm

https://www.oracletutorial.com/oracle-string-functions/oracle-length/