ThatJeffSmith

Tag: Toad

Toad for Oracle v11 Sneak Peek: PL/SQL Grammar Checking

Are you a PL/SQL developer? Do you think your IDE should promote better coding practices, and guide you to build more robust and reliable programs? If so, then Toad v11 might be just the IDE you are looking for. Toad version 11 introduces a new feature in the Professional and higher editions – Code Analysis. […]

Toad is now Frog

Quest’s most iconic product line, Toad, is being re-branded as Frog. For years we have lived the lie that this cute little guy was a Toad: He’s cuter, and easier to draw. We have to date, logged over 13,000 bugs with our Support department from biologists and amphibian/reptile experts that we do not have a […]

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

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

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

Toad for SQL Server: Program Your SSMS SP Keys

It happens more often than I like to admit, but I was asked a question about Toad that I could not figure out. A co-worker was trying to help a customer emulate a SSMS feature – the ability to program stored procedures to a keyboard shortcut or keystroke sequence. I got part of the way […]

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