PL/SQL是否具有与Java等效的StringTokenizer? [英] Does PL/SQL have an equivalent StringTokenizer to Java's?
本文介绍了PL/SQL是否具有与Java等效的StringTokenizer?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用java.util.StringTokenizer来简单地解析Java中的定界字符串.我在pl/sql中需要相同类型的机制.我可以编写它,但是如果它已经存在,我宁愿使用它.有人知道pl/sql的实现吗?一些有用的替代方法?
I use java.util.StringTokenizer for simple parsing of delimited strings in java. I have a need for the same type of mechanism in pl/sql. I could write it, but if it already exists, I would prefer to use that. Anyone know of a pl/sql implementation? Some useful alternative?
推荐答案
PL/SQL确实包含一个基本的逗号分隔列表(DBMS_UTILITY.COMMA_TO_TABLE
).
PL/SQL does include a basic one for comma separated lists (DBMS_UTILITY.COMMA_TO_TABLE
).
示例:
DECLARE
lv_tab_length BINARY_INTEGER;
lt_array DBMS_UTILITY.lname_array;
BEGIN
DBMS_UTILITY.COMMA_TO_TABLE( list => 'one,two,three,four'
, tablen => lv_tab_length
, tab => lt_array
);
DBMS_OUTPUT.PUT_LINE( 'lv_tab_length = ['||lv_tab_length||']' );
FOR i IN 1..lv_tab_length
LOOP
DBMS_OUTPUT.PUT_LINE( '['||lt_array( i )||']' );
END LOOP;
END;
/
或查看此Ask Tom链接以获取其他想法...
Or see this Ask Tom link for other ideas...
这篇关于PL/SQL是否具有与Java等效的StringTokenizer?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文