Opening Unshared Worksheets via the Keyboard

thatjeffsmith SQL Developer 0 Comments

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 is an Unshared Worksheet? An unshared worksheet is a SQL worksheet that has a dedicated …

POST Up a BLOB to an Oracle Table via REST

thatjeffsmith ORDS 3 Comments

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 table. The record will consist of a couple of regular values, but also a file, …

Oracle Open World 2017: What You Need to Know

thatjeffsmith General 1 Comment

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 (including the upcoming SQLDev Web) OTN Developer Day VirtualBox Appliance Lots of fun source code, …

Bulk Load an Oracle Table from CSV via REST

thatjeffsmith ORDS 4 Comments

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 REST Data Services & Auto REST for tables. With this feature, you can say for …

ORDS: Returning Raw {JSON}

thatjeffsmith ORDS 9 Comments

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 not just dealing with a CLOB, it’s actually JSON. Here’s that media post… The Media …

SQLcl and the the ORDS JDBC Driver

thatjeffsmith ORDS 0 Comments

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. No access to the database via the Listener required. Wanna play? Maybe the easiest way …

Swagger Doc for ORDS RESTful Services

thatjeffsmith ORDS 4 Comments

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 care about REST? The Movie Screenshots for Those that Can’t do YouTube at Work It’s …

What is the Future of Oracle SQL Developer?

thatjeffsmith SQL Developer 18 Comments

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 browsing and managing database objects Ad Hoc reporting Database Design & Data Modeling Database Administration …