select things_that_look_the_same_but
from the_optimizers_point_of_view,
are_different
where we_clog_up_the_library_cache = 'Y'and cause_extra_hard_parses = 'Y';
SELECT things_that_look_the_same_but
FROM the_optimizers_point_of_view,
are_different
WHERE we_clog_up_the_library_cache = 'Y'AND cause_extra_hard_parses = 'Y';
SELECT THINGS_THAT_LOOK_THE_SAME_BUT
FROM THE_OPTIMIZERS_POINT_OF_VIEW,
ARE_DIFFERENT
WHERE WE_CLOG_UP_THE_LIBRARY_CACHE = 'Y'AND CAUSE_EXTRA_HARD_PARSES = 'Y';
A good argument for standardising SQL formatting is that different people writing the same SQL statement
will all write it the same way, reducing the chance of this issue occurring