select * from t1 ,(select name from t2) view1 where t1.name=view1.name;如果想强制view1不展开，是用 /*+ no_unnest */还是/*+ no_merge */?B A no_unnest B no_merge