Toad® Stuff (Retired)

Aug 25, 2011

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 Continue reading →

JeffS Toad for Oracle, Toad® Stuff (Retired) 6 column, datatype, filter, oracle, schema browser, Toad

Aug 17, 2011

He Ain’t Heavy, He’s My Table

Many of our Toad users need to work with really wide tables. By ‘wide’ I mean a table with many, many columns. Oracle currently supports a maximum of 1,000 columns for a table or view. If that includes you, then we can help you. Ok, maybe you don’t have a 1,000 columns, but I’m guessing Continue reading →

JeffS Toad® Stuff (Retired) 2 columns, data grid, table

Aug 16, 2011

Toad Video: Compare & Sync Table Data Across Servers

Sit back and relax as I take you through one of my favorite Toad features: Data Compare. In less than five minutes see how to: Set your data comparison target and source Configure which columns to compare Use WHERE clause filters to limit data compared View the results Synchronize the data (optional)

JeffS Toad® Stuff (Retired) 4 Compare, Data, Toad, video

Aug 12, 2011

I Hate it When Toad Gets in My Way!

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 Continue reading →

JeffS Toad for Oracle, Toad® Stuff (Retired) 4 code, oracle, Toad

Aug 8, 2011

Getting Your Execution Plan, The Hard Way

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 →

JeffS Toad for Oracle, Toad® Stuff (Retired) 0 explain, Toad

Aug 3, 2011

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 →

JeffS Toad for Oracle, Toad® Stuff (Retired) 2 oracle, software, Toad

1 2 3 4 5 6 7 8