I want to develop a query that filters by a variable.
I have found multiple examples that say I need to use DECLARE block. So, I tried what works in a PL SQL package. It does not work in SQL Developer.
So, using SQL Developer, how do I create a variable, set the value and then use it like illustrated below...
