随笔分类 -  Oracle

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 Scarface 阅读(12312) 评论(2) 推荐(0)

导航