title: How to use variables in a select statement in Oracle PL-SQL
body: <p>I have a simple query that I can run in toad.</p>
  
  <pre><code>select * from my_table 
  where my_id = 11111;
  </code></pre>
  
  <p>Why can't I run the same query from toad this time declaring a variable and using it in the where clause?</p>
  
  <p>In sql server I would:</p>
  
  <pre><code>declare @testID int
  set @testID = 11111
  select * from my_table 
      where my_id = @testID;
  </code></pre>
  
  <p>How can I accomplish the same in Oracle 11g?</p>