I needed to publish a blog post this week, but instead of writing new content, I thought I’d share with you things I’ve written in other places. In no particular order: I Installed SQL Developer, Now What? – Medium REST for the DB Professional – What’s in it for you? – UKOUG Scene Automatic REST – Oracle Magazine Are Oracle’s Database Tools as good as Toad? – Quora Is Online Advocacy Making me a Grouch?…
Developers hate using a mouse. Sticking with the keyboard reminds everyone we bled all over our keyboards 20 years ago in VT100 terminals. So we built a modern command line interface for Oracle Database and released it last year, in 2016. And knowing you already know and love the keyboard, we made sure you could do what you needed to do while building and running your scripts and statements. So here’s a video showing you…
I wrote recently about using REST to upload a file to your table with ORDS. I want to extend that and share more code. I want you to see how to not only load the pics, but then how to get a collection of items, with links to those items, and in this case, also links to the media (pics) which we’ve uploaded. AND IT’S SO LITTLE CODE. What I’ll share: table ddl a few…
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 want my line numbers. Maybe you forgot you could right-click in the gutter. Or maybe…
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 those – thanks again Community folks! A few improvements. Code Outline It wasn’t working for…
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 database connection behind it. These come in handy when your database connection is busy doing…
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 let’s say you’re working on a report, and the column order is very specific. Now, you could use the INSIGHT/POPUP feature, but those names come back in alpha order. Or…
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, samples, and docs on GitHub Projects I can’t talk about yet The Talks We have…
Oracle REST Data Services happily converts your Oracle results to JSON for your REST APIs. But what if your results are already formatted as JSON? This post shows how to fix that!
Don’t have direct access to your Oracle Database, but do have Oracle REST Data Services? Your Java apps can make JDBC connections via our mid-tier with our REST Driver! Here’s an example with SQLcl.