Oracle转换字符串为数组
摘要:1. CREATE OR REPLACE TYPE mytable AS TABLE OF varchar2(500);2. 方法:CREATE OR REPLACE FUNCTION SEND_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 := InSt
阅读全文
posted @ 2011-07-04 10:48
浙公网安备 33010602011771号