In this post, I will show two simple ways to create a StringTokenizer function in PL/SQL. One way is to use regular expressions using the functions REGEXP_SUBSTR and REGEXP_INSTR provided by Oracle. The Functions REGEXP_SUBSTR and REGEXP_INSTR are merely an extension of their function INSTR and SUBSTR in Oracle. The STRINGTOKENIZER_REGEX function, which you can see below, it behaves like the class StringTokenizer in Java, that’s by removing all the tokens that are NULL. The result will be a DBMS_SQL.varchar2_table with all valid tokens. Let’s see, now, the code:
Entries Tagged 'Database' ↓
A StringTokenizer Function in PL/SQL
October 9th, 2009 — Database
PL/SQL Integration - Part 1 - Using External Services
April 17th, 2009 — Database, System Integration
More and more we need, for several reasons, to integrate the legacy systems with external services. In this post, we only briefly describe some possible integration between client-server legacy systems, with business logic written in PL/SQL, and Java Services. Continue reading →
