ThatJeffSmith

Tag: filter

30 SQL Developer Tips in 30 Days, Day 11: Tree Trimming

Many of you are not DBAs or developers. You spend most of your time browsing tables, running queries, and answering questions that help make your business ‘go.’ The SQL Developer Connection Tree shows a whole lot of stuff that you might not ever use. So turn it off. Tools – Preferences – Database – Navigation […]

Oracle SQL Developer 4: A Tweak With Table Filters

In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you. A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4… If You Want Help, […]

Why Can’t I See My Tables in Oracle SQL Developer?

Because you don’t have any tables. I hate to be the bearer of bad news, but you don’t actually ‘OWN’ any tables. What you mostly likely DO have are SYNONYMS that point to tables in a application schema. When you log on to Oracle, you are seeing this: The solution is simple! Enable Synonym Support […]

Search and Browse Database Objects with Oracle SQL Developer

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

SQL Developer Quick Tip: Filtering Object Lists

How deep do you go in your software? Do you make it at least 1 click deep? I’m talking about right-clicking with your mouse. Software folks are often accused of hiding things on context menus, but you have to remember that software is engineered and developed by folks that are comfortable with computers – and […]

SQL Developer Quick Tip: Filtering your Data Grids

Regardless of your role or responsibility, if you work in the database, you’re going to spend a lot of time looking at data. This is usually what will push someone from the command-line to a GUI – the spreadsheet look and feel for browsing tables or query results. Since you’re going to be spending so […]

Can’t See the Trees for the Forest

Yes, I know – the phrase is actually supposed to be the opposite, “Can’t See the Forest for the Trees.” One of the reasons English is such a hard second language to pick up apparently is all the idioms and non-literal phrases we use. So in case you’ve never heard this phrase before, it basically […]

Finding Tables Having Columns of Specific Datatypes

I frequently need to find a table in a particular SCHEMA, or even just anywhere in the database, that stores data of a specific datatype. This generally happens when a customer asks me, ‘Hey, does Toad support the ANYDATA|LONG RAW|CLOB|BLOB datatype?’ So I decide to find said table and just show them what the application […]

Toad Trick: Filtering Schemas in Oracle

In five minutes see how you can save yourself a few seconds every time you want to switch from one schema to another in Toad. You can read more about filtering in Toad in my blog post from several years ago – Finessing Filters and Other Fun Features. More Toad Videos Liked this but looking […]