title: Bind Variable When Creating Table?
body: <p>I'm trying to create a table that is filtered by a variable date, depending on the current date. Though I'm fairly new to Oracle and PL/SQL, I have already successfully written a number of "high beginner" PL/SQL procs. But I wonder if I'm taking the right approach using a variable to accomplish my goal. A simplified version of what I want to do:</p>
  
  <p>Create Table myTable as 
  Select * from oldTable where
  effective_date is > variabledate</p>
  
  <p>Perhaps this is better accomplished using a case statement within the query itself instead of using the case statement to create a variable and then using the variable in the query. But I'm thinking a variable would be more streamlined, easier to read, and possibly run faster.</p>
  
  <p>I've googled and searched, but most of what I find tries to tell me <em>how</em> to write it, rather than if my approach is the most efficient. </p>
  
  <p>Any thoughts/suggestions greatly appreciated!</p>