oracle将字符串转成数组_oracle 数组与字符串的 转换

[type tt_type is table of varchar2(32) INDEX BY BINARY_INTEGER;   --使用”,”将分割字符串转换为数组，返回为数组个数，  --闫磊   Email:Landgis@126.com,yanleigis@

字符串转数组：[如何从 PL/SQL 存储函数中返回数组类型   思路：在 Oracle 数据库中创建 VARRAY ，在Java Application中使用 oracle.sql.ARRAY 类 访问 VARRAY   VARRAY

(SELECT REGEXP_SUBSTR('34,56,-23', '[^,]+', 1, LEVEL, 'i') AS STR

FROM DUAL

CONNECT BY LEVEL <=

LENGTH('34,56,-23') - LENGTH(REGEXP_REPLACE('34,56,-23', ',', '')) + 1)

数组转字符串

select wmsys.wm_concat(cityname) from sys_city

where provinceid='29'[CREATE OR REPLACE TYPE mytable AS TABLE OF varchar2(100)/  CREATE OR REPLACE FUNCTION split (src VARCHAR2, delimiter varchar2) RETURN mytable IS psrc VARCH