ThatJeffSmith

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: , ,

SET PAUSE ON

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: , , ,

CYGWIN and SQLcl

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,