- 博客(2)
- 收藏
- 关注
RSS订阅原创 Oracle相关笔记
1、Like 用法 select * from SET_FAULT_INFO where comments like ‘%摆角%’; 2、删除重复数据 delete from SET_FAULT_INFO T where T.rowiD in( select a.rowid from( select rowid,row_number() over(partition by INDEX_NO order by INDEX_NO) rn from SET_FAULT_INFO) a where a.rn>
2021-12-03 15:03:24
120
原创 Oracle
Oracle Oracle Study 删除数据 delete from a_cids_workorder_info where orderno like ‘2018%’; 创建新表并拷贝旧表内容 create table POOLS_INFO1 as select * from pools_info; 增加字段 alter table a_pools_info add ( NORTH_TRANSITOFFSET_X NUMBER, SOUTH_TRANSITOFFSET_X NUMBER, EAST_
2020-09-21 12:10:56
217
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人