title: How to use variables in an Oracle PL/SQL where clause
body: <p>I can't seem to get variables to work in an Oracle PL/SQL where clause.  I come from a Microsoft SQL Server background and there it was easy.  For example, what would be all steps needed to do something similar to the following?</p>
  
  <pre><code>declare @var int set @var = 1
  
  select * from SomeTable where SomeField = @var
  </code></pre>
  
  <p>This doesn't seem like it should be hard in PL/SQL, but evidently it is.  :-/  I hear I need to use cursors and the like in PL/SQL?</p>
  
  <p>Any help would be greatly appreciated.  Thanks.</p>