sql
深深梦
这个作者很懒,什么都没留下…
展开
-
SQL删除重复数据只保留一条
delete from FND_EMPLOYEES a where a.employee_code in (select b.employee_code from FND_EMPLOYEES b where b.employee_code = i.employee_code group by b.employee_code having count(b.employee_code) > 1) an...原创 2020-09-26 23:44:29 · 312 阅读 · 0 评论 -
SQL 按逗号分割
SELECTREGEXP_SUBSTR('4CD1D4E27263EBBB482581ED0003B7E6,4B2A107B5BA2D3BC482581EC0003CF7C','[^,]+',1,LEVEL)ASNOTICE_NOFROMDUALCONNECTBYREGEXP_SUBSTR('4CD1D4E27263EBBB482581ED0003B7E6,4B2A107B5BA2D3BC482581EC0003CF7C','[...原创 2020-09-16 23:11:01 · 1577 阅读 · 0 评论 -
Oracle数据库 小数类型创建
在Oracle数据库如果有小数类型可以用float和decimalfloat 准确度比较低一些decimal 准确度高一些原创 2020-09-16 14:26:46 · 2911 阅读 · 0 评论