/**通过SQL实现小于一万时展示数据库里面的数据，大于一万时转化为万元**/
select decode(sign(money - 10000), -1,
money || '元',
round(trunc(money / 10000, 3), 2) || '万元') as money from dual;

select caa.objectId, listagg(c.Id,'||') with group (order by caa.objectId) as Ids
from collateral c left join collateral_amount_assign caa
on caa.calid = '1' caa.xx= c.projectId group by caa.objectId