explain plan in sqlplus

column PLAN_TABLE_OUTPUT format a90 truncate

set autotrace traceonly explain



with data
as
(select count(*) cnt from t )
select t.*, data.cnt from t, data


with data
as
(select /*+ MATERIALIZE */ count(*) cnt from t )
select t.*, data.cnt from t, data