Dynamic pivot

report error:
ORA-00904: "D"."PRES": invalid identifier

xml pivot

Job36ANALYSTCLERKCLERK1MANAGERManagerPRESIDENTSALESMANTesterkjljljljlpmpruebatest
100001100200010
200120013200000
300020000000000
400100010000100
 1000000011001
As described here by fac586 (Paul MacMillan)