title: Declaring a Variable and using it as a Parameter
body: <p>I am trying to write some code which will declare a variable and then use it as a parameter. I use this in SQL all the time, but don't seem to be able to figure out how to do it in PL/SQL and have not found any info that has helped me figure it out.</p>
  
  <p>Here is an example of what I have tried.</p>
  
  <pre><code>DECLARE
    DEPT VARCHAR2(50) := 'HDS - ITS Storage Services';
  
  BEGIN
     SELECT 
        SUBMIT_DATE,
        CLOSE_DATE, 
     FROM 
        sm_admin.ocmlm1
     WHERE 
        ASSIGNED_DEPT = DEPT
  END;
   / 
  </code></pre>