How to I create a view in Oracle where I can pass a parameter to it?
<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>