How to parse comma delimited string in PL/SQL?

Have a look at @TonyAndrews blog: tonyandrews.blogspot.com/2004/10/parsing....

You should probably change your response to a link. – TERACytE Aug 11 at 15:37 +1 from me of course! – Tony Andrews Aug 11 at 15:58 @Tony Andrews: I did wait a few minutes to give you a chance to answer.. ;) – StevieG Aug 11 at 16:00.

There is another technique outlined here blogs.oracle.com/aramamoo/entry/how_to_s... basically using regexp_substr.

If you are on Oracle 10G or 11G then you should have a built-in Apex function apex_util. String_to_table: SQL> declare 2 v_array apex_application_global. Vc_arr2; 3 v_string varchar2(2000); 4 begin 5 6 -- Convert delimited string to array 7 v_array := apex_util.

String_to_table('alpha,beta,gamma,delta', ','); 8 for I in 1..v_array. Count 9 loop 10 dbms_output. Put_line(v_array(i)); 11 end loop; 12 13 -- Convert array to delimited string 14 v_string := apex_util.

Table_to_string(v_array,'|'); 15 dbms_output. Put_line(v_string); 16 end; 17 / alpha beta gamma delta alpha|beta|gamma|delta PL/SQL procedure successfully completed.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.