MEMBER OF is a logical comparison operator : MEMBER OF « Collections « Oracle PL/SQL Tutorial






SQL>
SQL>  DECLARE
  2     TYPE list IS TABLE OF NUMBER;
  3     n VARCHAR2(10) := 'One';
  4     a LIST := list('One', 'Two', 'Three');
  5   BEGIN
  6    IF n MEMBER OF a THEN
  7     dbms_output.put_line('"n" is member.');
  8    END IF;
  9   END;
 10   /
 DECLARE
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 4








26.21.MEMBER OF
26.21.1.MEMBER OF Operator
26.21.2.MEMBER OF is a logical comparison operator
26.21.3.MEMBER OF operator finds if the left operand is a member of the collection used as the right operand
26.21.4.MEMBER OF table collection