title: How to use a package constant in SQL SELECT statement?
body: <p>How can I use a package variable in a simple SELECT query statement in Oracle?</p>
  
  <p>Something like</p>
  
  <pre><code>SELECT * FROM MyTable WHERE TypeId = MyPackage.MY_TYPE
  </code></pre>
  
  <p>Is it possible at all or only when using PL/SQL (use SELECT within BEGIN/END)?</p>