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 …
Enforcing Naming Standards for Your Data Models
Customer asks: We tried also to apply some naming conventions but I think we didn’t understand something…. Having a logical model with a table having the column X, and a glossary having the standard name as Y. Can I apply some checks based on the …
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 …
Everything You Need to Know about the Data Grids
Here’s a 15 minute video showing you everything you need to know about using the data grids in Oracle SQL Developer. Basically: settings fonts and look & feel column sizing column(s) sorts client side filtering copy & paste tricks single record view complex data type …
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 …