As I promised earlier, the focus of this blog entry will be using the Editor in Toad for Data Analysts. The Editor is where you can enter your own SQL code to query the database. Since you’re already familiar with Toad for Oracle’s Editor, you’ll notice some similarities in Toad for Data Analysts. Hopefully, these similarities will...

This blog covers testing the SQL alternatives in a development environment when it is not possible to do extensive testing in the production environment.

In Part III of this series of blogs, I’ll discuss the Query Builder in Toad for Data Analysts. In my previous entry, I said that I would talk about both the Editor and the Query Builder in Part III. Both features are so rich that I feel that separating the topics would be the best approach. So, we’ll focus on the Query Builder for this topic. 

...

Sometimes people will have a problem getting a TOAD feature to work – such as the PL/SQL debugger or profiler. For example a user might run TOAD and not be able to select or highlight the debugger icon on the main toolbar. So when they’re in the editor they cannot seemingly invoke or use the debugger. The initial conclusion is that TOAD must have a bug. But 90% of the time, it’s actually a database setup issue. Your DBA’s must grant TOAD users certain Oracle rights for some TOAD features to function. For example in both Oracle 10g and 11g, a TOAD user must have been granted the privilege DEBUG CONNECT SESSION for the debugger to function. We even have this specific information on the ask toad wiki. Since this privilege is not part of any of the pre-canned roles for Oracle 7 backwards compatibility (i.e. CONNECT, RESOURCE, DBA), we get this very question all the time.

...

Written by Richard To

 

This blog is the third in a series about misconceptions surrounding SQL tuning that are quite common. It covers the misconception that there is always some SQL syntax that is the best across different databases and hardware environments.

 

A lot of so-called SQL experts on the internet give you advice on how to write a better SQL or how to tune your SQL statements. I agree...

Running Toad for Oracle in a 64 bit environment is really pretty easy and straight-forward, you just have to follow the installation instructions and verify your environment is setup properly. I have created a short Power Point that shows the steps you need to follow. These instructions come directly from the installation guide as well. I hope this helps you with your installation. Mark

In Quest SQL Optimizer when you generate alternative SQL statements for your original SQL statement you may be presented with hundreds of SQL alternatives. The only way to be completely sure that you have the fastest one is to run all the SQL alternatives. But unless the SQL statements run relatively quickly, this is not always practical. So then you are left to determine which SQL statements you should select to test.

I was on the phone with a Quest Code Tester user the other day and he asked me if I was working on the next edition of my original "magnum opus", Oracle PL/SQL Programming, which would include Oracle11g features.

 

I cannot describe to you how good it felt to say: "No, I'm not working on it. I'm finished working on it."

 

In fact, just...

So if you’re reading this blog, hopefully that means you’ve just finished watching my ‘Discover the Hidden Treasures of Toad for Oracle, Developers’ presentation at our 2009 Toad Virtual Expo. If not, then you can still watch this 45 minute presentation for the immediate 60 days after the conference.

What I wanted to do here is go into a little bit more detail than what I could deliver in a powerpoint presentation. I’ll try to add a little flavor to the ‘Hidden Treasures’ we exposed for developers and point you to some other resources on ToadWorld that might help you on your way.

...

Written by Steven Feuerstein. Version 1.8.3 of Quest Code Tester is now available.

In this blog, I hope to be able to help you understand how Unicode is handled on your Windows PC/notebook and how to configure your PC/notebook in order to be able to effectively use Unicode in Toad.

Previously, we discussed how to establish connections to the database. If you’re interested in a refresher, the entry can be found here: http://www.toadworld.com/Community/Blogs/tabid/67/EntryID/382/Default.aspx Now that we’ve connected to the database, we’ll examine how to work with the database objects. 

 

Where are my...

As some of you may already be aware, we are releasing our next version of Toad (version 10.0) later this year and it will have one or two “under the cover” differences. Unicode support is one of those differences and is probably one of the most significant technology upgrades in Toad’s history.