Formatting Keywords to UPPERCASE In Oracle SQL Developer

thatjeffsmith SQL Developer 28 Comments

I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging 🙂 How do I go FROM: SELECT * FROM scott.emp WHERE ename LIKE ‘%JEFF%’ TO SELECT * FROM scott.emp WHERE ename LIKE ‘%JEFF%’ …

SQL Developer: Tastes Great, Less Filling?

thatjeffsmith SQL Developer 44 Comments

The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything but. SQL Developer is fairly scaled down. You have a few toolbars, several menus, and 2 driving windows – the Worksheet and …

Top 10 Preferences to Tweak when using SQL Developer

thatjeffsmith SQL Developer 179 Comments

Updated June 2015, current for version 4.1 There are too many options in our every day lives. We love asking for more options, but I often find myself being overwhelmed by the number of questions I have to answer before I can accomplish very mundane tasks. Do you want your latte ‘skinny’ or your cappuccino ‘wet?’ Waffle House customers are …

Partitioning and DBMS_REDEFINITION

thatjeffsmith Database Stuff 1 Comment

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I would love to hear about …