Skip to content
Advertisement

How to use date variable in sql developer’s “Enter Binds” dialog?

I am trying to run a query from sql developer and query has variables (:var). I am having problem with the date variables.

I used all the possible combinations to format date using to_date() function. Every time getting below exception:

Sorry can’t post image here

Advertisement

Answer

Try changing your query to be:

then when prompted, enter '20-JAN-2010'.

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement