Let’s say you have a schema you want to reverse engineer and generate some docs. Lo and behold, the developers used foreign keys! But…there are so many of them, I can’t see the forest for the trees. So how do we make this simpler? Well, our developer for the Data Modeler showed me this trick: In his words: when use synonyms is checked tables that are referred more than 9 times are removed from global…
The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle developer to do? Code/Roll your own REST Service. The ‘bespoke’ solution took me about 3…
I’m in Denver today, to present one of my favorite talks, SQL Developer Tips & Tricks. Since I know most of you won’t be here today, I thought I’d share 3, super-quick tips. I get asked ‘how to do this’ type stuff, all the time. Copying Column Headers with your Data Ctrl+Shift+C Showing Line Numbers Right-click in the gutter, turn it on. It’ll remember this going forward. You’ll need to do it for the…
I see questions like this on StackOverflow and related websites like, ALL THE TIME: I have some code, what’s wrong with it? Something I wish I could do, other than physically hold the person’s hand, is show them how our IDE tries to point them in the right direction of their syntax issues. But since I can’t do that, I’ll write a quick blog post and help the Google gods can help folks going forward.…
What are people Googling out there, when it comes to SQL Developer? Well, Google predictive text makes that kinda easy to find out. I’m going to address these questions, but we need to address the biggest problem – without context of the actual question, I have to assume or guess what the ACTUAL question is. But, I will go for the most likely scenarios. If I got it close, but missed, feel free to dig…
A relatively new feature, Proxy User Authentication allows you to connect using someone else’s credentials. Or as Oracle-Base puts it: Since Oracle 9i Release 2 it has been possible to create proxy users, allowing you to access a schema via a different username/password combination. This is done by using the GRANT CONNECT THROUGH clause on the destination user. So I’m going to alter a user, SCOTT, to allow for this. 59385523969bfd475f1e10_000008 Now, how do I…
When executing scripts in SQL Developer, the amount of output we display on the screen is LIMITED. By design, we only show you 5,000 records from any query, and we limit the amount of output in total for a single script execution to 10,010 rows. This is controlled here: I know what you’re thinking… Why? A few reasons, but practicality is what it boils down to. Displaying 3M rows of script output in a GUI…
I’ve talked about the Cart a few times. It’s interesting to describe what the Cart is for, because it can be used or so many different things. But in general, it allows you do perform a set of operations against a collection of database objects. In this case I’m going to show you how to export several views and tables to an Excel file. And the rest of this blog post will be done using…
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…
