03 2017 档案

Connection.setAutoCommit使用的注意事项(转)
摘要:http://ygsilence.iteye.com/blog/1297762 阅读全文

posted @ 2017-03-30 13:07 迷茫中寻找方向 阅读(684) 评论(0) 推荐(0)

java.sql.SQLException: Could not commit with auto-commit set on
摘要:This kind of exceptions occur when the Oracle JDBC Driver (ojdbc6.jar) version 12 or above will be used. Version 12 and above of the driver is more st 阅读全文

posted @ 2017-03-30 13:06 迷茫中寻找方向 阅读(2205) 评论(0) 推荐(0)

ORA-01555 snapshot too old
摘要:http://blog.csdn.net/songyang_oracle/article/details/6432182 http://blog.csdn.net/jamesxsy/article/details/7701302 阅读全文

posted @ 2017-03-15 16:53 迷茫中寻找方向 阅读(311) 评论(0) 推荐(0)

刷新组的维护
摘要:http://blog.csdn.net/aqszhuaihuai/article/details/7207779 阅读全文

posted @ 2017-03-14 20:39 迷茫中寻找方向 阅读(130) 评论(0) 推荐(0)

oracle merge 目标表以及源表存在重复列的问题(转)
摘要:SQL> select * from t_source; A B 1 1 2 2 SQL> select * from t_target; A B 2 34 2 3999 SQL> merge into t_target using t_source on (t_source.a=t_target. 阅读全文

posted @ 2017-03-13 09:12 迷茫中寻找方向 阅读(416) 评论(0) 推荐(0)

oracle 查看 job 日志
摘要:select * from user_scheduler_job_log select * from user_scheduler_job_run_details select * from user_scheduler_running_jobs select * from dba_schedule 阅读全文

posted @ 2017-03-09 16:02 迷茫中寻找方向 阅读(5115) 评论(0) 推荐(0)

oracle view and MATERIALIZED VIEW
摘要:View http://blog.csdn.net/tianlesoftware/article/details/5530618 MATERIALIZED VIEW http://blog.csdn.net/tianlesoftware/article/details/4713553 384/555 阅读全文

posted @ 2017-03-09 14:51 迷茫中寻找方向 阅读(244) 评论(0) 推荐(0)

Oracle dblink
摘要:http://czmmiao.iteye.com/blog/1236562 http://xuexin25.iteye.com/blog/1924622 阅读全文

posted @ 2017-03-07 11:39 迷茫中寻找方向 阅读(167) 评论(0) 推荐(0)

导航