Sir
see my query
how to get pivot result as per group by
can i use this code ” IN (select deptno from scott.dept) for multi dept “in pivot query

WITH pivot_data AS ( 
          SELECT deptno, job, sal 
          FROM   scott.emp 
          ) 
  SELECT * 
  FROM   pivot_data 
  PIVOT ( 
             SUM(sal)   
         FOR deptno     
  IN  (select deptno from scott.dept));  

Please guide me
Regard