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 […]

Tech Republic: Spamaholics

February 11 2010 by B-Drive in Uncategorized |No Comments

I read articles on Tech Republic from time to time. They’re . . . . OK. But I don’t remember signing up for this kind of email notification. You’d think a self proclaimed tech site would show a little more ethical behavior. Just goes to show you, their opinions are motivated. Here’s my recent inbox. […]