本文共 341 字,大约阅读时间需要 1 分钟。
Select case when HEX(name) like ‘000000000000000000000000000000000000000000000000000000000000’ then ‘NODATA’ else name end as ParticipantName from abc where co = ‘1286’
and code= ‘C163210889’Select case when REGEXP_LIKE(hex(name),’^[0]{60}$’) then ‘NODATA’ else name end as ParticipantName from abc where co = ‘1286’
and code = ‘C163210889’转载地址:http://uxwji.baihongyu.com/