oracle hint

 with t as (select /*+ materialize */) * from tab)

select * from t;

转载于:https://blog.51cto.com/traveler/1029853