When i ran first query it's working fine but in second query where i used pivot showing as "invalid identifier"
1. select deptno
, job
, avg(sal) sal_avg
from emp
group
by deptno
, job
2.select *
from table( pivot(' select deptno
, job
, avg(sal) sal_avg
from emp
group
by deptno
, job
')
)