Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to join two arrays together?

RichardSquiresJun 4 2009 — edited Jun 5 2009

I have the following type

    type TVarcharArr is table of varchar(4000) index by binary_integer;

I have a procedure that passes in two separate arrays as:

    p_account_number                 in TVarcharArr,
    p_product_system_code          in TVarcharArr

These arrays are related (they will have the same number of elements), the contents would be as follows:

    Account Number    Product System Code
    123                      ABC
    456                      DEF
    789                      GHI

I can use TABLE(CAST to turn each of these arrays into a table, but how do I join these two arrays together so that they become a single table with two columns? Or if I CAST them as TABLEs, how can I join these two tables together - is there some way of using the index to facilitate the join?

Cheers

Richard

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 3 2009
Added on Jun 4 2009
13 comments
5,540 views