Toad for Oracle

News, tips, tricks, and other fun facts about the most popular Oracle database tool.

Still use Notepad? I bet I know why.

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 grammar checker or a utility to ‘out-think’ [...]

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