Skip to Main Content

SQL & PL/SQL

How to merge two INDEX BY tables?

CGMSFeb 23 2010 — edited Feb 23 2010
Hi All,

Is there any way to merge the two INDEX BY tables?

i tried MULTISET UNION DISTINCT from the below link:
http://www.oracle.com/technology/oramag/oracle/03-sep/o53plsql.html

I got the PLS:00306: wrong number or types of arguments in call to 'MULTISET_UNION_DISTINCT' error.

Code:

declare

TYPE rec_nbrchk IS TABLE OF test.rec_nbr%TYPE
INDEX BY BINARY_INTEGER;

rec_nbr_chk rec_nbrchk;
mlcl_scope_chk rec_nbrchk;
all_chk rec_nbrchk;

begin

all_chk := (rec_nbr_chk )
MULTISET UNION DISTINCT
(scope_chk);
end;

Thanks in advance.

Suresh.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 23 2010
Added on Feb 23 2010
9 comments
1,021 views