2 Replies Latest reply: Sep 16, 2013 1:51 AM by Billy~Verreynne RSS

    define set of values (numbers) in PL/SQL

    SaadNayef

      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