title: How to declare a Date variable in SQL Developer
body: <p>In SQL Server I do the following way </p>
  
  <p>DECLARE @Date DATE</p>
  
  <p>SELECT @Date=Max(date) from table1</p>
  
  <p>Final Out put</p>
  
  <p>SELECT * FROM Table2
  WHERE date=@Date</p>
  
  <p>But in the same way in ORACLE PL/SQL(Esp in SQL Developer ) , How can I declare the Variable?</p>
  
  <p>Advise and help please?</p>
  
  <p>Thank you in advance</p>