0 Replies Latest reply: Mar 26, 2013 5:51 AM by 900478 RSS

    Find Intersection of two array elements in Oracle 9i

    900478
      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.... :)