Dynamic pivot

Closest I've got to showing only PRES/PRESIDENT columns is to include where clause embedding substutition string such as job = '&P39_CEO.', but returns ora-01403 in this demo, works in 4.2
report error:
ORA-00904: "D"."PRES": invalid identifier

xml pivot

Job ANALYSTCLERKCLERK1ManagerPRESIDENTSALESMANkjljljljlpmpruebatesttest4
10 00100100101
20 03013200000
30 01000000000
40 10010001000
  00000010010
1 - 5
As described here by fac586 (Paul MacMillan)