首页 > 数据库技术 > 详细

What does a (+) sign mean in an Oracle SQL WHERE clause?

时间:2018-01-02 16:15:07      阅读:278      评论:0      收藏:0      [点我收藏+]

This is an Oracle-specific notation for an outer join. It means that it will include all rows from t1, and use NULLS in the t0 columns if there is no corresponding row in t0.

In standard SQL one would write:

SELECT t0.foo, t1.bar
  FROM FIRST_TABLE t0
 RIGHT OUTER JOIN SECOND_TABLE t1;

What does a (+) sign mean in an Oracle SQL WHERE clause?

原文:https://www.cnblogs.com/kakaisgood/p/8177368.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!