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 …
Opening Unshared Worksheets via the Keyboard
Customer Question: How can I open an unshared worksheet using just the keyboard? Ctrl+Shift+N on an existing worksheet is the easy answer. Customer Followup Question: But, if you’re currently ON an existing unshared worksheet, this won’t work. Then, you need to hit ALT+F10. Jeff, What …
POST Up a BLOB to an Oracle Table via REST
It seems kind of weird to do a blog post around a feature that’s fairly well documented, but this came up twice this week, so I figured I’d throw it out there. Scenario: I want to post up a record to be inserted into a …
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 …
Oracle Open World 2017: What You Need to Know
As always our team will be quite busy, with both social and technical activities. And in case you forgot, I’m on the team that brings you: Oracle SQL Developer SQL Developer Data Modeler SQLcl REST Data Services A ton of database service instance console UIs …
Bulk Load an Oracle Table from CSV via REST
I have 1,500 rows I need to shove into a table. I don’t have access to the database, directly. But my DBA is happy to give me a HTTPS entry point to my data. What do I do? Let’s look at a Low-Code solution: Oracle …
ORDS: Returning Raw {JSON}
ORDS is nice. It auto-formats your SQL or PL/SQL results and response to JSON before returning to your client or application. But what if you’re response is ALREADY in JSON? Like this: Bad ORDS trying to convert JSON to JSON Good You telling ORDS we’re …
SQLcl and the the ORDS JDBC Driver
You know what SQLcl is. You know what ORDS is. How do those two things go together? Well, in ORDS 17.3 (Early Adopter/BETA!), we offer a new feature that allows you to execute ad hoc SQL and SQL scripts via HTTPS POST calls to ORDS. …
Swagger Doc for ORDS RESTful Services
We’ve just released version 17.3 of Oracle REST Data Services – as an Early Adopter (BETA). Go Download ORDS 17.3 Now. There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls. Wait, why should I …
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’ …