Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618

    Unanswered: Coma Delimited Varchars

    Okie, I am fairly new to Oracle so please forgive me my ignorance.

    With a project I am working on they which to pass an Associative Array or a Coma delimited string of ID's and return all the records that match the ids.

    This was orginally done by generating sql within a stored procedure and executing that sql. They want to move away from this approach.

    Can anyone advise of a better way to do this and perhaps supply examples?

    Thanks.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    See this exchange on Ask Tom.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •