--LPAD自动在前面加数值,例子里面是0,凑足14位
select
'ZCZQ45' || LPAD((row_number() over(order by t1.C_PORT_CODE)+tmp_tbl.max_num), 14, '0') as abc
from bbb
lpad()函数和(row_number()over( order by )+ ...)
最新推荐文章于 2024-01-18 17:39:45 发布
--LPAD自动在前面加数值,例子里面是0,凑足14位
select
'ZCZQ45' || LPAD((row_number() over(order by t1.C_PORT_CODE)+tmp_tbl.max_num), 14, '0') as abc
from bbb