title: How to I create a view in Oracle where I can pass a parameter to it?
body: <p>I created a view in Oracle</p>
  
  <pre><code>SELECT *
  FROM CUSTOMER
  ORDER BY CUSTOMER_ID
  </code></pre>
  
  <p>This works fine I can run select * from MyView.</p>
  
  <p>How can I create a new view where I would pass a parameter to it?
  <br>Ex (Pseudo Code):</p>
  
  <pre><code>@LastName = 'Smith';
      SELECT *
      FROM CUSTOMER
      WHERE LAST_NAME = @LastName
      ORDER BY CUSTOMER_ID
  </code></pre>