A few things have changed when it comes to running SQL Developer on a Windows machine. In previous versions, the first thing you’d see when running SQL Developer would be a prompt asking for the location of Java. Turns out, it’s hard for Java applications to run without Java. On Macs and Linux/Unix environments, we [...]
Oracle SQL Developer Data Modeler v4.0 Is Now Available
The title says it all. Version 4 is now available, replacing v3.3 as the current version. What you need to know: Downloads New Features Release Notes Docs My Two Favorite New Features Comment Only Views If you need to publish or produce a diagram for less technical users, with just an overview of entities or [...]
Quick Tip: Snapshot Findings and ADDM Reports in SQL Developer 4
One of our bigger new features for version 4 is our new support for the Database Diagnostic Pack. We have a new interface for your ASH, AWR, ADDM reports, and snapshots, baselines, etc. I want to show you a quick navigation trick today: how to quickly go from snapshots with findings to the actual ADDM [...]
Oracle SQL Developer Data Modeler 4 User Interface Improvements
The name probably gives it away, but just in case you weren’t aware of this, Oracle SQL Developer Data Modeler is an extension of Oracle SQL Developer. They share a framework that is derived from JDeveloper. The latest framework has some new user interface widgets that were adopted directly from Netbeans. I’ve blogged a bit [...]
Diagram Printing to PDF in Oracle SQL Developer Data Modeler v4
We recently had to update our printing and PDF technology in Oracle SQL Developer Data Modeler. An issue arose after making the switch from Java 6 to Java 7. As is likely to happen, not only we’re we able to largely maintain the current feature set, we we’re also able to greatly enhance it. So [...]
Oracle SQL Developer and Database Auditing
Did you know Oracle SQL Developer allows you to configure Database Auditing and view your audit trails? Well, now you do! This is not new for version 4.0, but the screenshots in this post are from version 4.0. This feature is available under the DBA panel, which can be found on the View menu. I [...]
My Advice For Our New Hires
So for some reason, our New Hire Program invited me BACK to talk to our newly hired developers. I had an hour to talk about our development tools, but I wouldn’t call it training really. My colleague Joel does an actual 2 hour lab teaching them to use APEX – that’s closer to REAL training. [...]
How to Create Views for All Tables with Oracle SQL Developer
Got this question over the weekend via a friend and Oracle ACE Director, so I thought I would share the answer here. If you want to quickly generate DDL to create VIEWs for all the tables in your system, the easiest way to do that with SQL Developer is to create a data model. Wait, [...]
SQL Developer Data Modeler: On Notes, Comments, and Comments in RDBMS
Ah the beautiful data model. They say a picture is worth a 1,000 words. And then we have our diagrams, how many words are they worth? So our models describe how the data ‘works’ – whether that be at a logical-business level, or a technical-physical level. Developers like to say that their code is self-documenting. [...]
Defaults for Exporting Data in Oracle SQL Developer
I was testing a reported bug in SQL Developer today – so the bug I was looking for wasn’t there (YES!) but I found a different one (NO!) – and I was getting frustrated by having to check the same boxes over and over again. What I wanted was INSERT STATEMENTS to the CLIPBOARD. I’m [...]
SQL Developer Q&A from ODTUG Tips & Tricks Webcast
Another great webcast yesterday – if you’re a paying member of ODTUG you can watch the show for yourself in their archives. If not, you can get my slide deck off of SlideShare. About 150 of you brave souls sat through an entire hour of me talking and then 10 more minutes of Q&A. We [...]
SQL Developer: BLOBs and the External Editor
We already know how easy it is to view images and plain text with the BLOB editor, yes? But what if I have in my column a bunch of PDFs stored? I want to see that stuff without having to save the file, finding it, and then opening it. Why can’t I just automatically open [...]
SQL Developer Quick Tip: Reordering Columns
Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will [...]
Oracle SQL Developer Data Modeler 4 and Comment Display
A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this: Normal Relational Diagram to Relational Diagram with Comments to Relational Diagram with Comments ONLY Now the cool part is that I don’t have to pick. I can [...]
Oracle SQL Developer 4 and Auto Spec – Body Toggles
I’ve been running version 4 for so long, that I have trouble remembering if some features are new to version 4. Well, here’s a simple feature that IS new to version 4 that I think our PL/SQL friends will appreciate. Say that you’re looking at a PACKAGE SPEC member, like a FUNCTION, and I want [...]
Twitter
RSS
GooglePlus
Facebook