SQLDev Trick: Alphabetized Column List in the Single Record Viewer

thatjeffsmith SQL Developer 0 Comments

This trick’s title might actually be longer than the content – so guaranteed QUICK read! Question from a reader: is there a way to alphabetize the columns in the Single Record View? Quick Answer: No… Column order is usually something the application architect or data modeler deemed important, so we always show the column in the order in which they’re …

SQL Developer Data Modeler v3.3 Early Adopter: Link Model Objects Across Designs

thatjeffsmith SQL Developer 5 Comments

The third post in our “What’s New in SQL Developer Data Modeler v3.3” series, SQL Developer Data Modeler now allows you to link objects across models. If you need to catch up on the earlier posts, here are the first two: New and Improved Search Collaborative Design via Excel Today’s post is a very simple and straightforward discussion on how …

Oracle SQL Developer v3.2 is Now Available!

thatjeffsmith Expired 19 Comments

Today we released the latest version of Oracle SQL Developer – v3.2.09.23. The official resources: SQL Developer on Oracle Technology Network (OTN) Release Notes New Features SQL Developer Forum I’ll showcase a few of my favorite new features and tweaks in the next several days and weeks, but I thought I’d kick things off right now with a new ‘trick!’ …

SQLDev Tip and Trick: Drag and Drop to Worksheet

thatjeffsmith SQL Developer 26 Comments

Updated 9/28/2018 Writing Code is for Suckers Yes, I’m joking, mostly. But if you’re in a tool, and it can help you save time, then why not? Here’s a simple scenario: building a SELECT statement for one or more tables/views. Dragging and dropping tables to the worksheet is a pretty obvious feature – it copies the object names over for …