摘要: oracle “ with as ”短语,也叫做子查询部分。 如果一个sql片段被重复使用或者sql本身比较繁琐,可以考虑将sql片段单独拿出来,起一个别名。 例: with e as (select from scott.emp), d as (select from scott.dept) se 阅读全文
posted @ 2016-05-16 13:30 南村一哥 阅读(291) 评论(0) 推荐(1)