This week was ‘visit customers and show off Toad’ week. I didn’t get a lot of questions, but one question did come up in almost every meeting – “How do we turn off that annoying popup thingy in the editor?!? I just want to type and Toad gets in my way!” The good news is [...]
Toad for Oracle
News, tips, tricks, and other fun facts about the most popular Oracle database tool.
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. [...]
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 [...]
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 [...]
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 [...]