oracel根据父级查询子集数据
摘要：select LEVEL lv, f2.* from F_UNITINFO f2 where exists (select 1 from f_userinfo u where 1 = 1 and u.is_valid = 'T' and u.user_word = 'SS' and u.primar
阅读全文
posted @
2022-11-30 16:30
IT-QI
阅读(51)
推荐(0) 编辑
oracel单表数据回滚
摘要：--开启修改分区键 alter table CJ_MONTH_CENSUS enable row movement; --回滚 flashback table CJ_MONTH_CENSUS to timestamp to_timestamp('2022-11-10 16:00:00','yyyy-
阅读全文
posted @
2022-11-10 16:52
IT-QI
阅读(26)
推荐(0) 编辑
