|
||||||
  |
Let me turn everything off with a single click! If you were to look at your most frequently used applications, I am betting you would find Notepad and Paint fairly high on your list. Why is that? Sometimes you just want a ‘dumb’ program to do a very specific task. The last thing you want is a [...] As we approach yet another release for Toad for Oracle, I thought it might be interesting to speculate what we might see going forward – whether that be in terms of months or years. Something I’ve always wondered is ‘just how long can this train keep running?’ It’s a personal and professional question for me, [...] I thought it would be cool to include some personal stories and quotes from people who have had a good experience with Toad. So, please step up and give me some juicy bits to share with my readers! I have nothing to offer but your future celebrity as tens of hundreds of people stumble upon [...] 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 [...] 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 can [...]
Sometimes help is more like harm. Eye of the beholder and all that jazz… 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 [...] 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. Read [...] 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 [...]
Power Tip: Let Someone Else (Toad) Row For You! 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 [...]  |
|
||||
|
Copyright © 2012 That Jeff Smith - All Rights Reserved 
This site has been fine-tuned by 3 WordPress Tweaks
|
||||||
Twitter
RSS
GooglePlus
Popular Posts