ThatJeffSmith

Category: Toad for Oracle

Toad for Oracle v11 New Feature: Read Only Connections

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

Building your WHERE IN () Lists

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

Kscope11 Database Development Symposium

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

More PL/SQL Fun in Toad version 11

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

Toad Tricks for PL/SQL Professionals

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

Format Files w/Toad via Command-Line

Your Problem: You receive code from developers who do not have access to Toad, or choose not to take advantage of Toad’s SQL & PL/SQL Formatter. Before checking their code into your source control repository, you need to format them so they meet your standards. The Solution: Toad for Oracle’s Automation Designer. Toad’s Automation Designer [...]

Capture and Replay Oracle Activity

Sound familiar? Perhaps you have heard of Oracle’s Real Application Testing (RAT) (docs)? An excellent feature, although you will pay for it. If you need a cheaper alternative, then Quest Software might have what you are looking for in Benchmark Factory for Databases (product details). New for v6.5, Benchmark Factory (BMF), now assists you in [...]

Elevenses

Everyone likes to read into numbers and significant dates. Numerology (wiki) attributes a connection from the world of numbers to the physical world. Even though I don’t believe in such things, I can’t help but take advantage of the opportunity to focus on the number ‘11.’ It’s eleventh day of 2011. Toad’s Development Manager is [...]

Three (4) Ways to get Data into Excel with Toad

I have been really hard on Excel lately. Excel is an excellent tool. Tools can be misused and abused, but it’s not their fault. I should know this being an advocate for Toad, but I digress. Updated on 1/5/2011 to include 4th Method and add note on ‘Display all results in grid’ option. You want [...]

Toad for Oracle Tip: Custom Queries

There are SO many little nuggets in Toad that you can take advantage of. To list all of them would be a daunting task. Here’s one that you may have overlooked, Custom Queries. If you right-mouse-click on an object in the Schema Browser, you’ll see a list of operations you can perform. Take a second [...]

My Toad Bible

Ok, I admit, I threw that title up because I wanted to draw attention to my site, guilty-as-charged. However, this is pretty close to being my ‘Toad Bible‘, i.e. my authoritative take on Toad. I reckon it’s my job to educate the market on all things Toad, so that’s where the authoritative piece comes in. [...]

Quest Backup Reporter for Oracle

Quest just released a new tool into the wild. DBAs and systems administrators can now get a better handle on the state of their Oracle backups with a very light-weigh easy to install tool called Quest Backup Reporter for Oracle. You can read a complete overview of the product here, but here are the basics: [...]

Toad on an iPad

No, we have not added native support for Toad to run on a platform other than Windows. No, I can’t tell you when that will happen. In the meantime, I thought you might enjoy a story about someone who has successfully setup his iPad to run Toad. @BigJim is a friend of mine on Twitter [...]

Reverse Engineer Views into an ERD

ERD – Fancy way of saying Entity-Relationship Diagram Since version 10.0 of Toad for Oracle, users have been able to select a table and have an ERD generated that automatically includes any related tables via Referential Integrity. However, what if you are trying to document a view which may bring in one or more other [...]

Sneak Peek at Toad for Oracle v10.6

I really should be more honest. In this case I’m referring to the title of this blog. ‘Sneak Peek’ infers I’m being naughty and showing you something that is secret or not available to the masses. The real story here is that any licensed user of Toad current on maintenance is able to participate in [...]