hey,
kann mir jemand sagen, was bzgl. des untenstehenden Stmt.'s nicht korrekt ist:
----------------------------
select * from (select PROCESS_KEY,max(decode(DESTINATION,'MAPS',FLAG)),max(decode(DESTINATION,'PDB',FLAG)),max(decode(DESTINATION,'SAP',FLAG)),max(decode(DESTINATION,'TRACE',FLAG)),max(decode(DESTINATION,'WIS',FLAG)),max(decode(DESTINATION,'WIS ST',FLAG)) from V_FLOWSYSTEM where DESTINATION is NOT NULL group by PROCESS_KEY) where rownum <= 10001
ERROR at line 1:
ORA-00972: identifier is too long
ORA-02063: preceding line from PDB_REF
-----------------------------
vielen Dank für Eure Hilfe.
mfG,
Markus.