oracle
幸运的崽~
没有什么是坚持做不到的!
展开
-
oracle修改换行空格回车符号
去除换行 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原创 2021-10-14 10:48:18 · 3241 阅读 · 0 评论 -
Oracle 常用总结
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 tt where tt.rid=1 Oracle trunc()函数的用法 日期 select trunc(sys原创 2021-08-16 15:17:48 · 341 阅读 · 0 评论