Connection.setAutoCommit使用的注意事项（转）
摘要：http://ygsilence.iteye.com/blog/1297762
阅读全文
posted @ 2017-03-30 13:07
03 2017 档案
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
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
刷新组的维护
摘要：http://blog.csdn.net/aqszhuaihuai/article/details/7207779
阅读全文
posted @ 2017-03-14 20:39
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
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
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
Oracle dblink
摘要：http://czmmiao.iteye.com/blog/1236562 http://xuexin25.iteye.com/blog/1924622
阅读全文
posted @ 2017-03-07 11:39
