ThatJeffSmith

I’m On Vacation – Go Read These Blogs Instead

I’m at the beach! But if you desire fresh SQL Developer-themed content, then you are still in great shape. Check out these blogs: The Data Warrior AKA Oracle ACE Director Kent Graziano Heli from Finland AKA Oracle ACE Director and published author Heli Helskyaho Kris Rice Colm Divilly Barry McGillin Not Enough? I have a […]

Similar Posts by Subject Areas: , , ,

Your Most Requested SQL Developer Demos

The team just got back from another Oracle User Group Conference, or I should say THE conference. I know most of you don’t get to go to conferences. Or have nice computers. Or use foreign keys. Or have nice things. BUT. One thing you do get to have today, is the same popular Oracle SQL […]

Similar Posts by Subject Areas: , , ,

Connection Filtering Across all Schema Objects

Most folks know they can filter their list of Tables. But did you know you can set a global filter across your entire connection? It’s pretty basic, but also pretty powerful: So how would this be useful? Maybe for your project or program module, you have all of the objects starting with the same prefix. […]

Similar Posts by Subject Areas: , ,

OT: Bad Tools Lead to Overly Verbose Code?

For some reason I decided to re-join a discussion in the SQL community from way back in 2012. THIS => "tbl_ is a tell for bad database design" via @datachick http://t.co/hq2BH73xic sorry @SQLRockstar — Jeff Smith (@thatjeffsmith) May 28, 2015 Karen started it, Thomas ran with it, and I decided I had to throw my […]

Similar Posts by Subject Areas: , , ,

SQL Developer Data Modeler, Pending Changes & Versioning

Oracle SQL Developer Data Modeler supports the one-gal design boutique shoppe and the mega-huge development team. It HAS a file-based repository (Subversion aka SVN.) You don’t have to use it, but you should. You can optionally store your designs and data dictionaries in a database for reporting purposes. I strongly recommend you do so. If […]

Similar Posts by Subject Areas: , , , ,

Trick: ‘Pasting’ SQL Developer Exports to an Outlook Message as an HTML Table

You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start your message. Attach File Point to your HTML File DON’T […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,