title: PL/SQL:, How to pass variable into SELECT statent and return all rows of results
body: <p>I am using an oracle database. I am used to SQL server but not familiar with PL/SQL for the Oracle database. 
  How do I Set a variable that returns all the rows that contain the value of that variable: I am lost, I tried to understand, but it is not making sense to me. This si a recent attempt I made to to this.</p>
  
  <pre><code>DECLARE date1 varchar(40);
  Begin
  Select '''07/31/2013_09%''' into :date1 from dual;
  End;
  /
  print date1
  
  
  Begin
  Select * from TABLE1 where start_time LIKE date1;
  End;
  /
  </code></pre>
  
  <p>I should get all the rows returned from this.
  Thank you for your help.</p>