select
CONCAT(SUBSTRING(SUBNAME, 1, LENGTH(SUBNAME) - 3), ‘')客户名称 ,
CONCAT(SUBSTRING(instaddress, 1, LENGTH(instaddress) - 3), '’) 用户地址
from dual;
PG sql 字段数据,隐藏后面三位数据
于 2023-10-23 12:52:03 首次发布
select
CONCAT(SUBSTRING(SUBNAME, 1, LENGTH(SUBNAME) - 3), ‘')客户名称 ,
CONCAT(SUBSTRING(instaddress, 1, LENGTH(instaddress) - 3), '’) 用户地址
from dual;