I get asked this question a LOT (especially from people looking to switch tools) – can your product help me extend a tablespace, i.e. make it bigger? But then, I also get this: we hate tools because the Junior DBA pages us at 3 in the morning when the tablespace is full, and they can’t extend them, because they don’t have the GUI in front of them. Let’s talk about the second problem first. If…
The feature that everyone knows about yet does not use? That would be the reports. I say that everyone knows about them because we throw them in your face..at least in terms of the user interface. It’s feature prominently next to where you see your database connections and objects. Yet, when I ask a room full of people, I routinely get about 10-15% positive responses. So, where is the disconnect? Do You Routinely Ask the…
I’ve talked about the query builder a bit here on these pages, but sometimes a quick video can do a much better job demonstrating these concepts. The video is about 8 minutes and covers: writing a query the old-fashioned way writing a query with drag-and-drop from the tree using the Query Builder At about 5 minutes in, I talk about why I think ANY SQL Developer user can get value from the Query Builder -…
There are many ways to open a file. File > Open is one, but apparently that’s too boring for many of our friends out there. For you new-fangled mouse people, let’s look at drag-and-drop. From the View > Files Panel Ok, But What About from Explorer or Finder Same difference, but there is one ‘trick’ to remember – you’ll need a worksheet or editor open first. Did you stay till the end of the movie?…
Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the column comments. Now imagine someone is asking you for a full accounting of these so they CAN be documented. If…
I normally don’t blog on Sundays. But I was going through our Exchange, triaging your enhancement requests, and I found one that is ALREADY in the product. Actually I found a dozen or so that are already in the product, but I thought I’d talk about this one in particular. From Describe (Shift-F4) allow “Copy column names to clipboard” like SomeOtherTool Description: For example, I want to clone one or more existing records in a…
I recently got this request for help via a YouTube video comment. I’m sharing it here, because I see this type of question A LOT. And it scares me. “When I run this script it reads = Error starting at line : 1 in command – What am I doing wrong? Before I show the code, let’s get this out of the way. I’m happy to help people. But as a ‘tools guy,’ I shouldn’t…
Author’s note: in the current Developer Day image, port forwarding on 1521 is there out-of-the-box for easy connections to your Database. This isn’t a SQL Developer post per-se, however if you are using the Oracle Developer Day VirtualBox 12c image, you will find this useful. A few of you have noticed that it’s difficult to connect to your Oracle Database from your computer if it’s running on this image. One Twitter friend asked just yesterday……
Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free. So for no money, you can design your database objects, and version control them for one or more people. I’ve put together some slides for your enjoyment: Oracle SQL Developer Data Modeler – Version Control Your Designs from Jeff Smith Psst, slide #16 has the ‘good’ stuff But Wait…
We actually have THREE patches for you: Oracle SQL Developer 4.0.1 Oracle SQL Developer Data Modeler Oracle REST Data Services, formerly Oracle APEX Listener, 2.0.6 Bug Fixes, Mostly SQL Developer had a few dozen or so bugs that have been addressed. A few major fixes of note include the new ASH/AWR stuff not working when connected to RAC instances, and the debugger being busted when trying to use watches. The Modeler had it’s fair share…