Your Definitive Guide to SQL History

I went to link to this post earlier today, and was shocked to discover I hadn’t actually written it yet. What’s the opposite of ‘bazinga!’ ? SQL Developer stores every query AND script you execute in a worksheet. A query being a single statement, and a script being one or more queries and/or anonymous blocks. […]

Similar Posts by Subject Areas: , , ,

5 SQLDev Features I’m Thankful For

I hope this post isn’t too cheesy. But it’s Turkey-week here in the USA, and the theme demands that homage be paid. So here are 5 features in Oracle SQL Developer that I use all the time, and am truly thankful for. They help me conserve energy, AND they make my job easier. I want […]

Similar Posts by Subject Areas: , ,

Making Your Own Custom Object Navigators

The Connection Tree and Schema Browser make pretty nifty object navigators. But maybe you want your own custom list of objects. Perhaps you’re working on a project and you only want to see objects that pertain to Project XYZ. And you’re able to ID these objects by a common column ID – or use your […]

Similar Posts by Subject Areas: , ,

Click vs Type…Again.

This might sound preachy, but it’s mostly not intentional, mostly. You might really enjoy the flexibility of the PL/SQL APIs the database provides for things like Resource management, the Scheduler, Data Pump. You might even have memorized the PL/SQL function/proc names and arguments required to create a job, or change up a resource. But do […]

Similar Posts by Subject Areas: , , ,

Object Search in SQLcl?

I’m always looking for things. I love the ALT+G trick in SQL Developer. But what about the command-line? One of the really nice things about SQLcl is that if you can’t do what you want with the available commands, you can just build your own. That’s especially true now that we have JavaScript support. But […]

Similar Posts by Subject Areas: , , ,

Keyboard Shortcuts Cheat Sheet

Remember back when Corel first released WordPerfect? Remember how it had like a bazillion keyboard shortcuts, and you needed help remembering them all? No? You probably also don’t remember a world sans e-mail and smart phones either. Oh well. Anyways, we have lots of keyboard shortcuts in SQL Developer and a few in SQLcl. You […]

Similar Posts by Subject Areas: , ,

SQL Developer and RAC

Yeah, we support RAC. Note, we did fix quite a few RAC related bugs in the 4.1.1 update. These screenshots were taken with version 4.1.2. When you want to look at historical data in ASH or AWR, you’ll have to specify the Instance number to pull the report from. And the report… Or if you […]

Similar Posts by Subject Areas: , ,


This has been around for a loooooong time. But after a short chat with @oraclebase AKA Tim Hall yesterday, I thought I’d make sure we’re doing things right in the SQLDev tooling. Tim uses it to make very nice, short, and sweet video demonstrations on his YouTube Channel. I highly recommend it. Anyways, back to […]

Similar Posts by Subject Areas: , , , ,

Just another GIF: Debugging PL/SQL

Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of […]

Similar Posts by Subject Areas: , , ,


For those Windows users out there who want both a BASH shell AND a really cool command line interface to Oracle Database – I have good news! We updated SQLcl yesterday to include support for CYGWIN. I have Cygwin64 and Windows 7. We also added a new command, SHOW TNS. This will help you figure […]

Similar Posts by Subject Areas: , ,

More on XML Extensions in Oracle SQL Developer

I’ve written a few posts on this subject… Intro to Extensions Adding Synonym Support with Extensions Adding an Error page for Views with an Extension Also, there’s two VERY nice resources for you that I recommend: My predecessor Sue Harper talks extensions in Oracle Magazine Mike Smithers has an exhaustive blog post on adding context […]

Similar Posts by Subject Areas: , , ,

The SQL*Plus Stuff You Like and Love Lives On in SQLcl

When demonstrating SQLcl, I get the feeling that half of the audience is filled with dread. Yes, they love everything that I’m showing them. But deep, deep down they are scared that the things they personally liked in SQL*Plus are going away. I’m here today to alleviate those concerns. Instead of asking you to just […]

Similar Posts by Subject Areas: , ,

Designing Surrogate vs Natural Keys with Oracle SQL Developer

I’m a fan of both. When describing an Entity, I like to keep it ‘real.’ My beer or brewery doesn’t have an ‘ID.’ But when I go to manage this data in the real world, I don’t want 3 or 4 columns used to uniquely identify a record in my table. Or tuple if you […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,