Oracle

语法：
with 视图名称 as（构造视图的语句）
（select 字段1，字段2 from 视图）
例：
with a as
(select to_char(sysdate,'yyyy-mm') as mm from dual)

(select a.mm from a);