Forum Stats

  • 3,836,791 Users
  • 2,262,192 Discussions
  • 7,900,112 Comments

Discussions

Find Intersection of two array elements in Oracle 9i

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.... :)
Tagged:
This discussion has been closed.