Função LENGTH Oracle

A função length busca a quantidade de caracteres na coluna last_name.

SELECT employee_id, CONCAT(first_name, last_name) NAME,
job_id, LENGTH (last_name),
INSTR(last_name, 'a') "Contains 'a'?"
FROM employees
WHERE SUBSTR(job_id, 4) = 'REP';

resultado:

EMPLOYEE_ID NAME JOB_ID LENGTH(LAST_NAME) Contains 'a'?
150 PeterTucker SA_REP 6 0