You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in the number or shape of packages left for you? Have a SPEC but No Body?…
Yes, it’s that time of year again. Let’s take a quick look back at the posts (from 2017!) you read the most. SQL Developer v17.2 is now available SQL Developer v4.2 is now available Release News, What’s On Tap (where I announce our new numbering scheme) Real Time SQL Monitoring Update What is the Future of SQL Developer? Oracle Database 12cR2 is Now Available – and so is our new VirtualBox Appliance Developer Oracle REST…
In SQL Developer you can configure how you want things to work for your session. How DATES should appear. If numbers should use a ‘.’ or a ‘,’ to indicate group separators and decimal points. We try to guess these things based on your local machine settings, but you can of course override them. But let’s see what happens when you DO set something. I’m going to change a whole bunch of stuff, stuff that’s…
For 17.4, the formatter will attempt to format invalid SQL for you. If the parser runs into a problem recognizing your code, it will format it as much as it can. But that’s not all. It will ALSO go to the end of your statement, and traverse the SQL in the other direction and continue formatting as far as it can. Let’s look at an example: Before But hey, let’s format it anyway. Cause hey,…
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…