MEMBER OF table collection : MEMBER OF « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. MEMBER OF

SQL> CREATE OR REPLACE PROCEDURE member_of_example AS
  2    TYPE charTable IS TABLE OF VARCHAR2(10);
  3    emp1 charTable;
  4    result BOOLEAN;
  5  BEGIN
  6    emp1 := charTable('A', 'B', 'C');
  7    result := 'A' MEMBER OF emp1;
  8    IF result THEN
  9      DBMS_OUTPUT.PUT_LINE('''A'' is a member');
 10    END IF;
 11  END member_of_example;
 12  /

Procedure created.