DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Use associative array in SQL

  1. 03-10-2010, 09:30 AM #1
    aspdba
    aspdba is offline Member
    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
    Reply With Quote Reply With Quote
  2. 03-10-2010, 02:12 PM #2
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    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.
    Reply With Quote Reply With Quote
  3. 03-15-2010, 08:32 PM #3
    aspdba
    aspdba is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width