Use associative array in SQL
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Use associative array in SQL

  1. #1
    Join Date
    Aug 2002
    Posts
    115

    Use associative array in SQL

    Hi,

    Is it possible to use an associative array in a SQL in a procedure?

    Thanks
    Sam

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Yes. That's a pl/sql table.
    Check here http://www.oracle.com/technology/sam...har2/start.htm
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Aug 2002
    Posts
    115
    Thank you PavB.

    Actually I was asking if I could use associative arrays/PLSQL tables in a sql query in my package.
    I couldnt, But I could use nested tables instead.

    Thanks
    Sam

Posting Permissions

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



Click Here to Expand Forum to Full Width