We released SQL Developer version 17.3 while I was at Oracle Open World, so I didn’t have time to really blog it. Plus, we found this REALLY annoying bug. Obviously this was ‘no bueno’ – so we put out a patch. Version 17.3.1 is available …
Get the Right Columns, In the Right Order
Some of you are real fast typers, and don’t need this type of help. However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general. So …
The Quickest Way to Reverse Engineer Your Database to a Model
You have a schema. Someone else built it. You’ve just inherited it. Now you need to build an application around it. But, tell me more about this schema? No docs? That’s OK, you can build your own! 1. Connect to Your Database, Open a ‘Driving’ …
What is the Future of Oracle SQL Developer?
In the year 2000… No, let me start over. IN the year 2017, we have Oracle SQL Developer version 17.2. It started as Project Raptor in 2005. It’s got a pretty wide and deep feature set covering these areas: PL/SQL IDE SQL editor GUI for …
SQL Developer 17.2: Publish RESTful Service (GET) based on a Data Grid
Think building REST Services for Oracle Database is hard? Tooling around SQL Developer, browsing data, and thought to yourself, that would make a great Web Service? Now, you can quickly publish the query behind a grid to a new or existing ORDS Module. Just right-click! …
Look and Feel – Feel Free to Go Crazy
Apparently SQL Developer doesn’t look super awesome on some Windows high-resolution displays (Macs are apparently A-OK!) 4 and 5k monitors. But that’s OK – it’s fixed in Java 9, and that appears to work just fine with SQL Developer v17.2. But another question came up …
Upcoming Webcasts: Getting Started with SQL Developer, SQLcl, & ORDS
I get the impression that many of you have thought about getting more acquainted with our development tools and platforms here at Oracle. But I ALSO get the impression that many of you just haven’t had the time. So, I’m officially inviting you to participate …
Modeling JSON in Oracle Database Tables
Having an extra bit bucket in your tables is pretty easy now in Oracle Database 12c and higher. We offer native JSON support [JSON DOCS] – you can have a free form text column and store anything you want in it. AND, we pretty much …
SQL Developer v17.2 is now Available.
Time to download! Mostly bug fixes. the frequent ‘connection reset’ message should be GONE entering text data in a data grid cell and the cursor doesn’t advance should be FIXED having a @ or a ; in a comment in your query should work AGAIN …
SQL Developer: You’re Doing it Wrong [VIDEO]
We tried 15 minute talks at a conference last week, and I think they came out OK. I figured for the folks who weren’t able to come out to the conference, maybe you’d like to see the talk? So here it is. The basic gist …