Tokenize Strings in PL/SQL

When pulling delimited strings apart in PL/SQL (or SQL statements in these examples) you'd usually use something like this: WITH test_data AS (SELECT 'Diego Javier Llorente Ríos' as full_name FROM dual) SELECT SUBSTR(full_name, 1, INSTR(full_name, ' ...