Hi,
I'm writing a query within a stored procedure (inside a package), the following condition is part of the query
WHERE dept_id IN (1,2,3)
I want to define the set (1,2,3) in the declaration part so it's used later by many places in the package.
The question is that, what's the simplest solution -if any- to implement that...
something in pseudo code like:
CONSTANT DEPT_SET = (1,2,3);
..................
.................
WHERE dept_id IN DEPT_SET
Thanks