pl/sql
文章平均质量分 62
Enjoy_Perfect
Want to see somethin real scary达斯汀够
展开
-
左右连接
SELECT ename , dname FROM Emp, Dept WHERE Emp.Deptno(+) = Dept.Deptno 也可以写成: SELECT ename , dname FROM Emp RIGHT JOIN Dept ON Emp.Deptno = Dept.Deptno 此SQL文使用了右连接,即“(+)”所在位置的另一侧为连接的方向,右连转载 2012-10-04 13:03:46 · 256 阅读 · 0 评论 -
connect by prior
connect by 是结构化查询中用到的,其基本语法是: select ... from tablename start with 条件1 connect by 条件2 where 条件3;例:select * from tablestart with org_id = 'HBHqfWGWPy'connect by prior org_id = parent_id;转载 2012-10-04 13:33:15 · 332 阅读 · 0 评论