How to declare a Date variable in SQL Developer

Asked Apr 01 '15 at 22:26

Active Apr 01 '15 at 23:16

Viewed 2,799 times

In SQL Server I do the following way

DECLARE @Date DATE

SELECT @Date=Max(date) from table1

Final Out put

SELECT * FROM Table2 WHERE date=@Date

But in the same way in ORACLE PL/SQL(Esp in SQL Developer ) , How can I declare the Variable?

Advise and help please?

Thank you in advance

edited Apr 01 '15 at 23:16

asked Apr 01 '15 at 22:26

user3594484

possible duplicate of [How do I use variables in Oracle SQL Developer?](http://stackoverflow.com/questions/5653423/how-do-i-use-variables-in-oracle-sql-developer) – sqluser Apr 01 '15 at 22:40
Can I have the syntax specifically for DATE datatype. – user3594484 Apr 01 '15 at 23:17
`variable var DATE` `exec :var := '02-APR-2015'` – sqluser Apr 01 '15 at 23:26
Thank You SQL User. Problem here is I need the date to get dynamically like variable var DATE exec :var := select max(date) from table – user3594484 Apr 01 '15 at 23:29

0 Answers0