摘要: CREATE OR REPLACE TYPE mytable AS TABLE OF varchar2(100)CREATE OR REPLACE FUNCTION SPLIT(SRC VARCHAR2, DELIMITER VARCHAR2) RETURN MYTABLE IS PSRC VARCHAR2(500); A MYTABLE := MYTABLE(); I NUMBER := 1; -- J NUMBER := 1;BEGIN PSRC := RTRIM(LTRIM(SRC, DELIMITER), DELIMITER); LOOP I := INSTR(PSRC, DELIM.阅读全文
posted @ 2011-12-31 17:03 莫问奴归处 阅读(744) | 评论 (0) 编辑 |
