with 语句在oracle中 理解为:
临时创建的查询期间存在的VIEW ,这个VIEW仅在查询期间存在
with a as(select * from emp),b as (select * from empt)
select * from a,b where a.id=b.id(+) and b.id is null
oracle 中的 with
最新推荐文章于 2022-03-30 11:13:09 发布
with 语句在oracle中 理解为:
临时创建的查询期间存在的VIEW ,这个VIEW仅在查询期间存在
with a as(select * from emp),b as (select * from empt)
select * from a,b where a.id=b.id(+) and b.id is null