Toad

Quest Software has two of the most powerful tools for PL/SQL development:Toad for Oracle and SQL Navigator for Oracle.Personally, I spend more time working with Toad for Oracle and I truly enjoy the solution.Before I proceed any further, I want to clarify a point.I am not advocating one solution...

We are pleased to provide two new command-line utilities that were developed for the next version of JProbe. The first can be used standalone to obtain basic memory usage reports from JVM memory dumps...

This blog is the fifth in a series about misconceptions surrounding SQL tuning that are quite common. Around 15 years ago, when I was a DBA both for Oracle and Sybase, a lot of SQL came from my colleagues which I needed to tune...

I recently published the following puzzle in the ToadWorld newsletter: Which of the following queries return the names of programs (without duplication) defined in the currently connected schema whose source contains a call to DBMS_OUTPUT.PUT_LINE (assume that this program name does not appear...

It’s been a while since I wrote my data warehousing book, so I wanted to read something hip and new on the topic. Lucky for me someone suggested that I examine “Oracle Warehouse Builder 11g: Getting Started” by Bob Griesemer from PACKT Publishing. Whil...

Quick, what’s the number one complaint about Toad for Oracle? ...

Many people these days have to work on both traditional “online transactional processing” (i.e. OLTP) systems as well as data warehouses. But just what is a data warehouse? Ge...

Did you know that in Code Tester 1.8.5 you can now perform in-line validation of your customization code? For more complex tests, this will save you lots of time and make it easier to build your regression tests...

I want to start by thanking everyone who participated in the free TOAD book contest by submitting new feature ideas or enhancement requests. I received numerous good ideas. I also received about a third that were already in TOAD – and have been for a long time. ...

I was recently in Germany, and did an interview with Erik Franz of database|pro...

Oracle introduced support for XML in the relational database going back at least to about the 8i release.Toad for Oracle introduced formal support for XML in the 8.0 release...

In one of my previous lives, I worked at a startup company testing software.Our application used Oracle as the back-end and the nature of my role had me working closely with our Oracle DBA.As part of our processes, our DBA had to build documentation describing the schemas our application needed.The...

So with Toad v10 being released, my Tips & Tricks guide became a bit out of date. You can find an updated copy, as well as our v9 copy, here...

As I write this, I am flying back to Chicago now, 9 PM Oct 21, from Mexico City, after a very nice two day visit. Quest Mexico asked me to come down to help celebrate the release of Toad Version 10. I said "OK." And, wow, they did a really fantastic job of making me feel appreciated...