A Simple PL/SQL Tokenizer

February 12 2010 by B-Drive in Database |No Comments

DECLARE   tokenString      VARCHAR2 (256) := ‘Jim,Jerry,Jordan’;   tokenLength      NUMBER := 0;   tokenDelimiter   VARCHAR2 (1) := ‘,’;   tokenChar        VARCHAR2 (1) := ”;   tokenIzed        VARCHAR (30) := ”;BEGIN   SELECT LENGTH (tokenString) INTO tokenLength FROM DUAL;    FOR i IN 1 .. tokenLength   LOOP      SELECT SUBSTR (tokenString, i, 1) INTO tokenChar FROM DUAL;       IF tokenChar = tokenDelimiter OR […]