30 SQL Developer Posts in 30 Days, Day 22: It’s All in the Font

thatjeffsmith SQL Developer 0 Comments

Tell Others About This Story:

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

Note the drop-down control added to the Explain Plan button in the worksheet toolbar.

Note the drop-down control added to the Explain Plan button in the worksheet toolbar.

The Older Way

Ask for plan, show plan.

Ask for plan, show plan.

Ugh. That’s a little icky to read.

Remember – you need to set a fixed-width font.

Tools – Preferences – Code Editor – Fonts

Ahhh, that's much better :)

Ahhh, that’s much better 🙂

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.

A Font that's not non-English friendly

A Font that’s not non-English friendly

Exact same text, except rendered with the Tahoma font

Exact same text, except rendered with the Tahoma font

Related Posts

Tell Others About This Story:

Leave a Reply

Your email address will not be published. Required fields are marked *