The idea behind mirroring is the same as User Mapping in prior versions of Team Coding. Mirroring allows PL/SQL developers to operate on code objects in their own workspace (such as a development schema), make changes, and then finalize the original “controlled” object by compiling the latest revision from the VCS into the production schema.

Video 2 in this series covers the UI changes for Toad for Data Analysts 3.0. If you are interested in upgrading to 3.0 and would like to know about the following areas take a moment to watch!

Understand, Query, Report, Automate buttons (where did they go?) Right Click menus (Better usability) Oracle Connections (How to set up an instant client) Query Builder (How to add a column) Code Completion...

Written by Steven Feuerstein

My good friend, Marcelle Kratochvil, an expert in multimedia and PL/SQL, asked me to give you all notice about a new SIG she is establishing: the Oracle International Unstructured Data with Multimedia SIG. Here's a description of the SIG:

With iPhones, iPads, Android and other devices now dominating how we access information, businesses and the government are increasingly embracing...

In part one of this topic, I showed you how to convert a 10.6-generated CodeXpert INI file to a Toad 11 Code Analysis action by using the now deprecated –CX switch as part of the DOS command. In Toad version 11, Code Analysis can still be run from the command-line, but it will be in the form of an action...

Imagine a new DB2 developer or DBA joins your company and needs access to a lot of objects. He needs to connect to databases, use some tablespaces and of course work with a lot of tables. Now you have to grant him different privileges on different DB2 objects. It seems you have to do a lot of right clicks on a lot objects.

But there is an easier way to do this! You can focus on the DB2 object that changes, in our case...

With the release of Toad for Oracle version 11, the CodeXpert code rules engine has been transformed into Code Analysis. It is now easier to use, features more rules, is appreciably faster, and it can be saved as an action. But if you’ve got lots of configuration (*.ini) files left over from CodeXpert command-line runs, how do you retain them for use with Code Analysis?

I’m glad you asked.



Say you...

Before the advent of Windows Vista/7 and the oft-dreaded UAC, Toad for Oracle’s configuration settings were stored under the Program Files folder hive, where Toad’s runtime files took up residence. Things are different now. User Account Control and tighter system security have obviated the need for each user’s personal settings to be stored in an application data folder most commonly under C:\Users\. Beginning with Toad for Oracle 10.0, user settings are no longer stored in Program Files. This creates a bit of confusion when migrating from a pre-10.0 version of Toad to Toad 10.6 or the new Toad version 11. Here’s how to do it.

...

Toad for Data Analysts 3.0 is finally here! I’m sure you are all anxious to find out what’s in it and get started on playing with its new features. Here is a short video to get you going.

This is Video 1 of a series of videos covering the features of TDA 3.0.

If you would like to view them all please visit our community site.

Download a Trial copy...

Updated for Version 11! Using an older copy of Toad? That’s OK! Most of my favorite tips and tricks are for features that have been in the product for years!

How do I get started? There has to be a better way to get data to Excel. Toad is so busy, how do I simply the interface without sacrificing functionality? How do I make my SQL statement ‘go faster?’ After using Toad for 10 years, what am I missing?

I have...

Nancy recently wrote to me with the following question:

Steven, how does one avoid hard codes in views?  I have a very complex view that wants specific data from a multiple of tables - so there are multiple in ('xx','xyz','abc'....) and more.  I know it is a maintenance headache when hard codes are introduced, but not sure how to avoid them - short of creating specific tables that hold the values I want - which then...

Toad for Data Analysts 3.0 will be publicly available for download next week! This latest version has tons of cool features like an improved x-platform query engine, new data cleansing and transformation capabilities, a set of sophisticated analytics, data visualization, and even an embedded database. Don’t miss this webcast with product manager Julie Hyman and Software Engineer, Amit Parikh to see some of these new features...

I have a dream to build the world's best index advisor that solves for any number of SQL statements, from one to thousands, and auto balances its recommendation based on actual workload. My research in this area was carried out almost 10 years ago and the research paper completed around 6 years ago but due to some reasons we have been unable to implement it - until now. I have not been so excited since I created my first...

（原文： “OPTIMIZING SQL PART 3– GENERATING MORE SQL ALTERNATIVES FOR SIMPLE SQL STATEMENTS”  原文投稿日期: 2008年11月6日 星期四）

A quick review of the important features of the virtual Oracle SQL Tuning for Developers using TOAD

One of the things that gives me the greatest pleasure as I attend various Toad User Groups and Conferences around the world is the sheer enthusiasm for Toad amongst attendees and an ambition to learn as much as possible about Toad, not only from us at Quest Software, but from each other.



I remember...

Toad Extension for Eclipse allows you to specify Date Fomat output and input patterns. Output pattern affects displayed data and format the stored date in desired format. Input pattern offers you a way to use different format when adding new records to your database.Benefit: I can use European format for inserting records and US format for displaying records or generating HTML reports.