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 in a series of upcoming webinars I’ll be hosting. How they ‘work’ We’ll use a …
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 glossary directly in the logical or relational model? Yes, in fact you can. Basically how …
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 give you the full power of the SQL interface to those bit bucket items – …
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 many, many more bug fixes – see the release notes for details SQLcl updated, more …
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 support – Spatial & BLOBs dates & timestamps inserting multiple rows via PASTE I do …
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 of the talk: SQL Dev is a BIG, DEEP tool You don’t have time to …
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 get preachy in this talk, but I must admit it’s still a bit preachy. Oracle …
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 HR installed somewhere and HR is REST enabled, let’s build this package. CREATE OR REPLACE …
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. This is a LOW CODE solution. You could of course ALWAYS roll your own RESTful …
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 delivered by an embedded Jetty web server. Jetty is an Eclipse project. Very cool stuff …