Can’t Remember Your Keyboard Shortcuts? Try the Quick Action Panel.

thatjeffsmith SQL Developer 6 Comments

Quick post today. If you want to do something, but can’t remember the keyboard sequence, or can’t find the button, try opening the Quick Action panel. It’s available under the Tools menu. It offers a few features. You can search. You can see the keyboard shortcuts. And you can activate the feature immediately by double-clicking on the item. Like, I …

Help! Where do you go for help with Oracle?

thatjeffsmith Database Stuff 9 Comments

I’m running a week long poll on Twitter. After Google, where do you go for Oracle help, first? Please answer, then RT. If 'other', please specify in your RT. — Jeff Smith 🥃 ☜ (@thatjeffsmith) October 20, 2017 The problem with Twitter is that you’re limited to only 140 characters, so I’m afraid I failed to adequately word the question. …

Version 17.3(.1!) is Now Available

thatjeffsmith SQL Developer 18 Comments

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 now. What’s New in 17.3? Mostly bug fixes. We identified issues from 17.2 and fixed …

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 5 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 …