1 Reply Latest reply: Aug 29, 2007 11:11 PM by 807605 RSS

    String into array in oracle

    807605
      Hi,

      I have value in a column in oracle table as "DE","DS","KJ".

      now,How can I get them into string array?

      Is there any API to get this ..


      Thanks
      Chat
        • 1. Re: String into array in oracle
          807605
          I have value in a column in oracle table as "DE","DS","KJ".

          now,How can I get them into string array?
          Do you mean that you have a single string with quotes and commas? If so you have to parse it to extract the constituent strings. Ostermiller has a library that does this sort of thing (Google ostermiller csv) and deals with the complexity of commas and quotes within the quoted parts.

          (If you know the string value consists of quoted section separated by commas, and there is no possibility of spaces getting in the way, you could split the string based on "," and then take substrings to remove the quotes.)

          You should pick one thread for this and stick to it. Put a message in the other linking to the thread you want to use.