title: check if a value exists in array of constants in oracle
body: <p>I have some predefined values like </p>
  
  <pre><code>declare 
  v_type varchar2(20);
  begin
      select type into v_type from GenericTypes where id =5 ;
     // say v_type = 'XYZ'
  
  end;
  </code></pre>
  
  <p>Now, i have to check if v_type is equal to 'ABC' or 'DEF' or 'ASD' and 5 more items.</p>
  
  <p>so i used:
  <code>if v_type = 'ABC' or v_type ='DEF' or v_type='ASD'</code> and 5 more conditions</p>
  
  <p>If there is any more efficient method to do this like using select exist etc.</p>