with as 查询块只被调用一次, 默认不会做materialize, 可以用/*+ materialize*/的hint来使其物化生成临时表,如果with as 查询返回结果列中含有lob字段, 不能被materialize.