table alias and pivot function

[bubu2006]

can I write following SQL

SELECT *
FROM emp e
PIVOT (e.SUM(sal)
FOR e.deptno IN (10,20,30,40));

I am using Oracle 11G.

 

[SantaMufasa]

BuBu,

What happened when you tried it?

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”