摘要:
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
莫问奴归处
阅读(1520)
评论(0)
推荐(0)

浙公网安备 33010602011771号