Most Oracle IDEs (integrated development environments) these days make it really easy to get your SQL statement’s Execution Plan. Of course you have your theoretical plan, and then the actual plan that the database engine employs. You look in different places for those plans, but the tool generally makes that process invisible to the user. Continue reading →
Toad for Oracle
Why Did You Steal/Hide My Favorite Button!?!
Sometimes we get bored and change stuff in Toad just to mess with people. I’m pretty sure there are people out there that really believe that. In our defense, I will say that we do change things pretty frequently, but it’s always in the pursuit of improving the user experience. However, sometimes there are unintended Continue reading →
Manage All of Your Jobs Using Toad
I mentioned the other day what a pain it was to manage a database that had both DBMS_JOBS and DBMS_SCHEDULER being utilized to run jobs. One of my peeps, @Boneist reminded me it was even harder for her because Toad deemed it necessary to purchase an optional ‘DB Admin module’ to work with the DBMS_SCHEDULER Continue reading →
Row, Row, RowID Your Record, Gently Update the Table
You may have heard the term ‘ROWID’ many times without really stopping to think about what purpose it serves. The end user – or even the application developer themselves – will rarely have a need to interface with a ROWID. Even so, ROWIDs do a lot of cool things. According to Oracle, ‘They are the Continue reading →
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 Continue reading →
Toad 11 Sneak Peek Part Deux
I had some time to beta test this morning, and I thought I would share some of the new tweeks and features that will be available in version 11.0 of Toad for Oracle. I spent some time previously showing off a new feature for you PL/SQL geeks out there, Code Analysis. If you are a Continue reading →
Twitter
RSS
GooglePlus