Hi experts,
select
TO_CHAR(EVENT_MINUTE, 'MM-YYYY') AS EVENT_MINUTE,
-- select substr( XMLCast( XMLAgg(XMLElement(e, ','||APPLICATION)order by APPLICATION)as clob), 2) APP_LIST from stats_track_summary_by_min
PROCESS_NAME,contract as contract_list from (select
substr(
XMLCast(
XMLAgg(
XMLElement(e, ','||CONTRACT)
order by CONTRACT
)
as clob
), 2
) CONTRACT_LIST from stats_track_summary_by_min where process_name='ws_router'
union all
select contract from stats_track_summary_by_min where process_name!='ws_router' ),
While executing above query am getting below error, please provide your suggestion how can be modified to get union for contract list only process_name ='ws_router
and not for other process listagg is not working as lots of record sin table.
ORA-01790: expression must have sa
me datatype as corresponding expression
- 00000 - "expression must have same datatype as corresponding expression"
*Cause:
*Action:
Error at Line: 93 Column: 3