ORACLE PIPE ROW 将一个字符串分成多条记录
转载：http://blog.csdn.net/goodleiwei/article/details/11484991
- create or replace function row_split(var_str in string, var_split In String)
- return t_ret_table
- PIPELINED as
- var_tmp varchar2(4000);
- var_element varchar2(4000);
- n_length Number := length(var_split);
- begin
- var_tmp := var_str;
- while instr(var_tmp, var_split) > 0 loop
- var_element := substr(var_tmp, 1, instr(var_tmp, var_split) - 1);
- var_tmp := substr(var_tmp,
- instr(var_tmp, var_split) + n_length,
- length(var_tmp));
- pipe row(var_element);
- end loop;
- pipe row(var_tmp);
- return;
-
end row_split;
-
select * from table(row_split(area_str, ','))
|
|
COLUMN_VALUE |
| 1 | 111 |
| 2 | 222 |
| 3 | 333 |
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/17087603/viewspace-2136055/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- Costing Transaction Errors (文档 ID 1274319.1)
- CSTPLCIN.COST_INV_TXN
- No Sales Order Id Found in MTL_SALES_ORDERS (Datafix #23) (文档 ID 281836.1)
- EBS-COST：物料分配不产生的问题处理
- ap invoice status 【selected for validate】
- Reasons for incorrect gl balance
- EBS GL 凭证相关功能
- EBS客户创建
- AP 应付接口导入常见报错
- EB-Tax Data Corruption Issues & Recommended Solutions (文档 ID 1316316.1)
