We’ve been working on version 4.1 since last Fall, and I’ve been blogging about the new stuff all the while. In case you missed it, we officailly released version 4.1 yesterday 🙂
Here’s a quick index of all of those version 4.1 posts you may have missed:
- SET SQLFORMAT command and a new formatter, JSON
- a new Search and Replace interface
- Code Insight, more tweaks & improvements
- Easier Excel and CSV Imports
- Multi-Cursor (text, styping – not the other kind) Support
- Seeing the SQL that SQL Developer sends to the database
- Getting 4.1 up and going on a Mac with Java 8
- Our new Instance Viewer for DBAs
- Deploying and Running Oracle REST Data Services v3.0
That’s not EVERYTHING. But there was one other thing I wanted to call out, but I couldn’t find the exact post, so I’ll talk about it again.
Visualizing Relationships for Tables
No need to do a reverse engineer of your table just to see what else it’s related to, and how. Just click on the new ‘Model’ tab in a table editor.
If you have Foreign Keys, you’ll see more than just a picture of your table.
The driving table will be highlighted in a red border.
If you want to do anything with this ‘model’, you need to click the toolbar button to open it in an actual modeler design. Then you can make changes and generate ALTER scripts.
One thing you can do from this view immediately is see the table or relationship properties.
Like, why does Employees have a line that connects to itself?
Finding Related Content Here
Something you can do in WordPress is ‘tag’ your posts. I’ve been tagging any post that call out a version 4.1 feature with a ‘4.1’ WordPress Post ‘tag.’
At the end of every post now, you’ll see a list of tags. Clicking on it will pull up posts with those tags.
Be sure to let me know what else I can do here to make stuff easier to find!