title: How to check if an array contains a particular string?
body: <p>I have an array of strings. I want to check if a particular string is present in the array.</p>
  
  <pre><code>DECLARE
    TYPE v_array IS TABLE OF VARCHAR2(200);
    ais_array v_array;
  BEGIN
    ais_array := ('Lb1','Lb2','Lb3','Lb613');
    IF 'Lb1' IN ais_array THEN
       dbms_output.put_line('found');
    END IF;
  END;
  </code></pre>
  
  <p>The <code>IN</code> operator is not working. I tried doing a <code>select *</code> on the type and then using <code>IN</code> but that didn't work either.</p>
  
  <p>Any suggestions?</p>