Updated 8 August 2023 This feature has been removed, instead you can use the utPLSQL extension for SQL Developer. Wait, what is utPLSQL? It’s an open source library framework for writing PL/SQL unit test cases, implemented by writing PL/SQL. So it’s less GUI than SQL Developer’s feature was, but it’s MUCH MORE flexible and powerful. Download the extension If you’re on an older copy of SQL Developer with this feature still intact… If you want…
One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script. Now, what many of you don’t realize is that the way this code can be generated is configurable. The requests I am most frequently asked to demo here are: No storage parameters No schema notation Show me the grants! Actually, there’s another…
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……