with t as (select /*+ materialize */) * from tab) select * from t; 转载于:https://blog.51cto.com/traveler/1029853