title: Using "WHERE" with a variable that has multiple values
body: <p>I want to know how to select columns from a table where another column has several possible values. So, for example, this code will return Column X from table 1 and Column B from Table 2 if Column G has the value given by the input.</p>
  
  <pre><code>variable input varchar2(60);
  exec :input := 'c';
  
  Select Table1.x, Table2.b
    FROM Table1, 
         Table2
   WHERE Table1.g = :input
  </code></pre>
  
  <p>What if instead, I wanted to return Column X from <code>table1</code> and <code>ColumnB</code> from <code>Table2</code> if <code>ColumnG</code> had value "k" or "c" or "d" without doing </p>
  
  <pre><code>WHERE Table1.g = "k" or Table1.g = "c" or Table1.g = "d"
  </code></pre>
  
  <p>How do i define the input such that I get this effect?</p>
  
  <p>I use: oracle 10g, PL/SQL</p>