oracle的SQL语句中的(+)是干什么用的？

2025-01-24 02:29:56

推荐回答（3个）

回答1：

这个(+)是数据连接的意思，用于表外链接，外链接
举例：
select a.ENAME,b.ENAME from emp a,emp b where a.MGR=b.empno(+);--外连接内表或俩表比较有+端强制显示空结果
select a.ENAME as ben,b.ENAME as shangji from emp a,emp b where a.MGR=b.empno(+) and a.hiredateselect a.dname,b.* from dept a,emp b where a.deptno=b.deptno(+) order by b.empno;

回答2：

oracle特有的左外联书写方式，当然你也可以用传统的通用的左外联，比如给你举个例子
SELECT s.name AS 姓名,g.grade AS 分数,c.cid AS 课程名
FROM tbl_student s LEFT OUTER JOIN tbl_grade g ON s.StudentId=g.sid LEFT OUTER JOIN tbl_class c ON g.cid=c.ClassId
它跟下面等价
SELECT s.name AS 姓名,g.grade AS 分数,c.classname AS 课程名
FROM tbl_student s,tbl_grade g,tbl_class c
WHERE (s.StudentId=g.sid(+)) AND (g.cid=c.ClassId(+))

回答3：

外连接的意思。
请参考原厂手册中的说明：

Outer Joins
An outer join extends the result of a simple join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other satisfy the join condition.

1、To write a query that performs an outer join of tables A and B and returns all rows from A (a left outer join), use the LEFT [OUTER] JOIN syntax in the FROM clause, or apply the outer join operator (+) to all columns of B in the join condition in the WHERE clause. For all rows in A that have no matching rows in B, Oracle Database returns null for any select list expressions containing columns of B.

2、To write a query that performs an outer join of tables A and B and returns all rows from B (a right outer join), use the RIGHT [OUTER] JOIN syntax in the FROM clause, or apply the outer join operator (+) to all columns of A in the join condition in the WHERE clause. For all rows in B that have no matching rows in A, Oracle returns null for any select list expressions containing columns of A.

3、To write a query that performs an outer join and returns all rows from A and B, extended with nulls if they do not satisfy the join condition (a full outer join), use the FULL [OUTER] JOIN syntax in the FROM clause.

最新问答

如何辨别C语言中的字符常量,字符串常量和符号常量？

小学教师资格证笔试时写了语文，面试可以考数学吗？

用0，2，3，7，8这五个数字组成一个是2和3的倍数的三位数，其中最小的是______，最大的是______

三星note3 n9009电信版怎么使用卡2的网络？

最新的智能锁十大品牌是哪些品牌呢？

国庆火车票怎么那么难买啊?