As much as I like the traditional explain plan support in SQL Developer, and even the ability to pull cached plans out by the SQL_ID – sometimes you just want to get the plan the old fashioned way.
The New Way
The Older Way
Ugh. That’s a little icky to read.
Remember – you need to set a fixed-width font.
Tools – Preferences – Code Editor – Fonts
Fonts Are Very Important
If you’re having display issues with your data, it’s almost ALWAYS the font’s fault. Set a font that supports the characters and character sets you’re trying to display. You don’t have to worry much about corruption with SQL Developer because we natively support Unicode.