Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

display_plan.sql

Download Script

set pages 100
set lines 80
column statement_id format a2
column operation format a20
column options format a15
column object_name format a15
column id format 99
column parent_id format 999
column position format 999
select statement_id, operation, options, object_name, id, parent_id, position from plan_table
order by statement_id,id 
/