title: Using declare variables in Oracle
body: <p>I am having a syntax issue with the declaration in Oracle. I am using these variables on MS SQL server and they work just fine; however, how do I declare these in Oracle?</p>
  
  <p>Use in MS SQL server:</p>
  
  <pre><code>DECLARE @FROM_DT DATETIME
  DECLARE @END_DT  DATETIME
  DECLARE @LOCATION  VARCHAR(100)
  
  SET @FROM_DT = '04/01/2011'
  SET @END_DT =  '05/09/2011'
  SET  @LOCATION ='VA'
  </code></pre>