The risk of posting a question here, is that I might take it and turn it into a blog post. And that’s where today’s topic comes from. I imported data dictionary into SQL data modeler and cannot found out how to disable predefined constraint names. Table “T” was created in database without specifying primary key name, so it gained SYS_C0012093 name, but in data modeler constraint is named as “T_PK”. This produces unnecessary statements when…
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…
Someone on the Twitters was lamenting they had accidentally clobbered their code when they ‘copied over it’ in their clipboard. So basically you cut your code – it goes to clipboard, you copy something else, the :new replaces the :old. But. SQL Developer keeps an Extended Clipboard. It’s just what it sounds like. We keep a pretty decent Undo history as well. Now me, I never make mistakes. But for you good folks, these two…
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…
We have to rename Oracle SQL Developer – there’s not enough ‘Oracle’ in the name! So, I’d like to crowdsource some ideas. Here’s a few to get you started: Oracle SQL Developer for Oracle Oracle SQL Developer Unbreakable Oracle We Can’t Believe It’s Not Chargeable SQL Developer Yes, it’s April Fool’s Day, again. Yes, I’m out of blog ideas. Yes, I’m probably in trouble.
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 -…
As of last week, Steven came back to work with Oracle, on the database tools team. I first started working with Steven at another company, doing database tools stuff, and now we’re back together again! Ok, that’s a little dramatic sounding. I used to work with Steven, and now I do again 🙂 I think this will lead to our tools becoming even stronger and to our users becoming even more productive. This morning, I…
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’ve talked about how to make your really long sections of code easier to navigate by splitting your editors, but did you know we can make it easier to browse your tables and views too? No? Watch the movie then, you have 2 minutes to spare, yes? And seriously, don’t do the April Fool’s prank on someone unless they have a good sense of humor, and it’s not against your corp IT policy, and you…
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…