海崽的博客

去除换行update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(10),'');去掉回车update zhzl_address t set t.add_administration_num=replace(t.add_administration_num,chr(13),'');去掉空格update zhzl_address t set t.add_administratio

Oracle 常用总结Oracle 获取分组排序第一条row_number() over(partition by XXX order by XXX)select * from ( select row_number() over(partition by userId order by skillName) as rid ,* from skill) as ttwhere tt.rid=1Oracle trunc()函数的用法日期select trunc(sys