Building An Object Search for SQLcl

thatjeffsmith SQL Developer 0 Comments

The search feature in SQL Developer is whiz-bang. You’re using it, right? But what about at the command line? I’m guessing many of you just pluck away at ALL_ or DBA_OBJECTS. Some of you may have written some custom scripts. But, what if you burned that into SQLcl? You can of course do this with the ALIAS command. You can …

Finding Columns

thatjeffsmith SQL Developer 1 Comment

One of the most viewed threads over the last 30 days in our OTN Community for SQL Developer is a post from 2010. 2010. Wow, I says to myself – that’s gotta be interesting to a lot of folks, what is it? It’s a question on how to find table or view columns. And the ‘correct’ answer is to use …

SQL Developer 4.1: Search & Replace Enhancements

thatjeffsmith SQL Developer 4 Comments

In the procedure editor, the editor that’s invoked when working with PL/SQL objects, you will notice a slightly new user interface when invoking a search or a replace. Let’s cover search first. Already searched for something, and want to do it again? Check out the history. Start searching, immediately highlight all of the ‘hits.’ Remember how you can just double-click …

Search and Browse Database Objects with Oracle SQL Developer

thatjeffsmith SQL Developer 16 Comments

Having trouble finding something? Maybe you’re just getting older? I know I am. But still, it’d be nice if my favorite database tool could help me out a bit. Hmmm, what’s this ‘Find Database Object‘ thing over here…sounds like a search mechanism of some sort? You can access this panel from the ‘View‘ menu. It’s a good bit down the …

How to find dependent objects in your PL/SQL Programs using SQL Developer

thatjeffsmith SQL Developer 9 Comments

I’ve answered this question a few times over the past several months, but I’m just now getting around to putting my answer onto ‘paper.’ The common scenario is someone decides to alter a table. Immediately the paranoid – is it really paranoia if someone is actually out to get you? – start to worry about how many programs they’ve just …