摘要:
1 创建数据类型CREATE OR REPLACE TYPE str_split IS TABLE OF VARCHAR2 (4000);2 创建返回值为table的函数CREATE OR REPLACE FUNCTION P_TEST_TABLE(p_string IN VARCHAR2, p_delimiter IN VARCHAR2)/*拆分字符串函数*/ RETURN str_split PIPELINEDAS v_length NUMBER := LENGTH(p_string); v_start NUMBER := 1; v_index NUMBER;BEGIN WHILE(v_. 阅读全文