--
-- setup script for isecond blog post on SQL Patach
-- Author: Maria Colgan maria.colgan@oracle.com (@SQLMaria)

connect sh/sh

set pages 9999
set lines 150
set echo on

-- check the plan for our simple stmt again emp
explain plan for
Select count(*), max(empno)
From   (Select *
        From emp
        Where deptno=10);

Select * From table(dbms_xplan.display(format=>'basic +note'));

-- now add some whitespaces and change the case of our query
explain plan for
Select    COUNT(*), max(empno)
From   (Select *
        From emp
        Where deptno=10);

Select * From table(dbms_xplan.display(format=>'basic +note'));
--