![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
ORACLE
随风起浪
这个作者很懒,什么都没留下…
展开
-
oracle 解决sql in参数多、数据量大时查询效率低问题
1、使用union把多个参数生成一张参数表SELECT * FROM(SELECT '1' A FROM DUAL UNIONSELECT '2' A FROM DUAL UNIONSELECT '3' A FROM DUAL UNIONSELECT '4' A FROM DUAL UNIONSELECT '5' A FROM DUAL UNIONSELECT '6' A FROM...原创 2020-03-20 11:39:14 · 4174 阅读 · 0 评论 -
ORACLE DROP误删数据库表恢复方法
查询出被删除表名select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin order by DROPTIME desc;BIN$v7NJ2kOSQK69uG77XshGYw==$0 T_CHRYSLER_PARTS_BAK TAB...原创 2019-03-17 20:33:36 · 843 阅读 · 0 评论