What is the proper way to use variables with query-based values in a query in SQL Developer? Here is what I want to do:
- declare variable, e.g., v_date
- assign variable value based on query, e.g., (select last_day(sysdate) from dual)
- use variable in query
I have been a long-time Toad user and the method appears to be different from what I am use to. I have tried to find this info online and tried several variations, but for some reason I am having trouble. Any help is appreciated.