之前居然从来没见到过此类写法,诸如 select * from t_spolicy d,V_POLICYEMPLOYEE g where d.policyno = g.policyno(+)查阅相关资料才发现此法就是外联的另外一种表现形式其等同于select * from t_spolicy d left join V_POLICYEMPLOYEE g on d.policyno = g.policyno,同理 select * from t_spolicy d,V_POLICYEMPLOYEE g where d.policyno(+) = g.policyno,就等同于select * from t_spolicy d right join V_POLICYEMPLOYEE g on d.policyno = g.policyno Oracle超大数据导出为文本文件Spring MVC+Hibernate3 中遇到的问题相关资讯 Oracle基础教程
- Oracle块编程返回结果集详解 (11/10/2013 10:45:58)
- Oracle基础教程之设置系统全局区 (08/22/2013 14:24:00)
- Oracle基础教程知识点总结 (06/18/2013 07:43:32)
| - Oracle基础教程之tkprof程序详解 (10/22/2013 11:49:50)
- Oracle基础教程之sqlplus汉字乱码 (07/18/2013 16:30:00)
- Oracle 管理之 Linux 网络基础 (02/16/2013 18:37:35)
|
本文评论 查看全部评论 (0)