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 …
Three (3) Things You’re Not Using But Totally Should Be
Missed out on KScope17 this week, or were there, but missed out on my talks? Have no fear – you can now catch up on the 3 Oracle SQL Developer features that you should be using, but probably aren’t. I tried my best not to …
More on ORDS 3.0.10 and Auto PLSQL – PACKAGES
We released a new version of ORDS this week, and I blogged about a new feature in that release – Auto PLSQL. In that post, I briefly mentioned packages, but I wanted to take a quick moment to show that ‘live.’ So assuming you have …
Announcing ORDS 3.0.10 and a new feature – Auto PLSQL
New Oracle REST Data Services (ORDS) drop today. Per usual, mostly bug fixes And per usual, sometimes we like to sneak in new features as well, and this release is no different. You can now have ORDS automatically create POST handlers for executing your PL/SQL. …
Configuring Jetty in Standalone ORDS
For all of my ORDS demos, I’m running it as a standalone process. There’s no Tomcat or Apache involved – and that’s OK. Your needs may require otherwise, and that’s OK too. When running in a standalone configuration like this, ORDS’ HTTP(S) functionality is being …
Five (5) People to Follow On Twitter
I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even …