10g_compare.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 24 行

DECLARE
   TYPE clientele IS TABLE OF VARCHAR2 (64);

   group1   clientele := clientele ('Customer 1', 'Customer 2');
   group2   clientele := clientele ('Customer 1', 'Customer 3', NULL);
   group3   clientele := clientele ('Customer 3', NULL, 'Customer 1');
BEGIN
   IF group1 = group2
   THEN
      DBMS_OUTPUT.put_line ('Group 1 = Group 2');
   ELSIF group1 != group2
   THEN
      DBMS_OUTPUT.put_line ('Group 1 != Group 2');
   END IF;

   IF group2 != group3
   THEN
      DBMS_OUTPUT.put_line ('Group 2 != Group 3');
   ELSIF group2 = group3
   THEN
      DBMS_OUTPUT.put_line ('Group 2 = Group 3');	  
   END IF;
END;
/