ThatJeffSmith

Category: Database Stuff

Unit Testing Your PL/SQL with Oracle SQL Developer

If you want to unit test your PL/SQL, then Oracle SQL Developer can help make that easier for you. I’m not going to try to convince you to test your code, but if you’re already rearing to go, then read on. So I have a long history with unit testing tools for PL/SQL, but I […]

Oracle SQL Developer: Configuring Object DDL Scripts

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 […]

SQL Developer Quick Tip: Extended Paste

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 […]

Oracle SQL Developer: Extending a Tablespace

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 […]

Oracle SQL Developer’s Best Kept Secret: Reports

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 […]

Product Name Challenge!

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 […]

Oracle SQL Developer: Query Builder Video Demonstration

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 […]

Dragging and Dropping Files into Oracle SQL Developer

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’ […]

Finding Calculated View Columns

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 […]

More Column Copy Tricks in Oracle SQL Developer

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 […]

SQL Developer Video Tutorial: Split Those Grids

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 […]

How To Version Control Your SQL Developer Data Modeler Designs

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 […]

SQL Developer 4.0 Patch Release Now Available

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 […]