Skip to Main Content
Forums

DevOps, CI/CD and Automation

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!

Find Intersection of two array elements in Oracle 9i

900478Mar 26 2013
How to find intersection of two arrays in pl/sql for Oracle 9i.

it is feasible in 11g using given code but this code is not working in 9i please help....

DECLARE
abc LIST := list(1,2,3,4);
def LIST := list(4,5,6,7);
BEGIN
dbms_output.put_line(format_list(abc MULTISET EXCEPT def));
END;

Thanks in advance.... :)

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 23 2013
Added on Mar 26 2013
#9i, #oracle-provider-for-ole-db, #plsql, #windows-and-net
0 comments
1,321 views