1

I have a varchar2 field and want to split it to array of chars Like 'ABCDEF' --> 'A' 'B' 'C' 'D' 'E' How can i convert my Field Values to chars array?

MH2538
  • 169
  • 2
  • 4
  • 11
  • something like this http://stackoverflow.com/questions/14328621/oracle-10g-splitting-string-into-multiple-rows ? – A.B.Cade Oct 01 '13 at 06:44

1 Answers1

2

If you actually mean a PL/SQL collection of characters, you could do something like

SQL> ed
Wrote file afiedt.buf

  1  declare
  2    type char_arr is table of char(1) index by pls_integer;
  3    l_str varchar2(100) := 'ABCDEF';
  4    l_arr char_arr;
  5  begin
  6    for i in 1 .. length(l_str)
  7    loop
  8      l_arr(i) := substr( l_str, i, 1 );
  9    end loop;
 10    dbms_output.put_line( l_arr.count );
 11* end;
SQL> /
6

PL/SQL procedure successfully completed.

Without understanding the business requirements, though, I would tend to be very suspicious. When you find yourself breaking apart strings in PL/SQL, that almost always implies that you have stored data in a non-atomic form and need to address the data model issue.

Justin Cave
  • 227,342
  • 24
  • 367
  • 384