25 lines
544 B
SQL
25 lines
544 B
SQL
.
|
|
-- Copyright 2018 Tanel Poder. All rights reserved. More info at http://tanelpoder.com
|
|
-- Licensed under the Apache License, Version 2.0. See LICENSE.txt for terms & conditions.
|
|
|
|
0 explain plan for
|
|
|
|
set termout off
|
|
|
|
def _x9_temp_env=&_tpt_tempdir/env_&_tpt_tempfile..sql
|
|
def _x9_temp_sql=&_tpt_tempdir/sql_&_tpt_tempfile..sql
|
|
|
|
store set &_x9_temp_env replace
|
|
save &_x9_temp_sql replace
|
|
|
|
run
|
|
|
|
set termout on
|
|
|
|
select * from table(dbms_xplan.display(null,null,'ADVANCED'));
|
|
|
|
set termout off
|
|
@/&_x9_temp_env
|
|
get &_x9_temp_sql
|
|
set termout on
|