I am trying to run this SQL query on APEX SQL Commands and am receiving 'ORA-00933: SQL command not properly ended' How can I resolve this?
select * from (
select * from piv.IP_ASSET_TRACKER)
)
AS P
pivot (count(ID) for result in (Idea, Published)) as result;