How to merge two INDEX BY tables?
CGMSFeb 23 2010 — edited Feb 23 2010Hi 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.