![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL
jessdy
有多年删库跑路的经验
展开
-
ORACLE XE 字符集修改
connect system/oracle9i as sysdba shutdown immediate startup mount alter system enable restricted session ; alter system set JOB_QUEUE_PROCESSES=0; alter system set AQ_TM_...原创 2008-07-11 10:45:46 · 295 阅读 · 0 评论 -
ORACLE技巧一点点(不断补充中)
清空ORACLE回收站,ORACLE删除表后都会留下BIN$开头的回收表purge recyclebin; 即可清空回收站 两表结构相同求数据差异select * from A minus select * from B; 查出来的结果为存在于A表但不存在B表的记录...原创 2008-09-04 10:00:04 · 98 阅读 · 0 评论