Toad is a powerful tool. It can do a lot of work in a short amount of time. This work can be destructive. I maintain both a development and production instance. How bad would it be if I accidently dropped or truncated a table mistakenly in the wrong database? Of course I can only perform [...]
Toad for Oracle
News, tips, tricks, and other fun facts about the most popular Oracle database tool.
Have you ever needed to write a query and filter your results with a WHERE EXISTS or a WHERE IN list of values? Your list will be comma delimited, and you’ll need to quote the strings appropriately. Not so bad if you have a few values, but what if you have 42 or 420 or [...]
The Oracle Development Tools User Group’s (ODTUG) annual convention in Long Beach, CA kicks off on a Sunday with several Symposiums. There will be one dedicated to tools (link), and I’ve been asked to present Toad and how it helps with instrumenting your PL/SQL code. – ODTUG KScope11 June 26-30 (Details) – One of the [...]
You have some SQL in your PL/SQL program, and you need to execute it to see if it’s doing what you want. Today that means you need to extract the inputs, replace with binds, and remove the INTO syntax. What if Toad had a ‘magic button’ to do this work for you? In version 11, [...]
My first experiment with SlideShare! Interested in a free training session for Toad for Oracle? In about 60 minutes I can go over most of the features Toad has to offer for someone who works with PL/SQL. Take a look at the below presentation, and if you are interested, let me know. I can schedule [...]