Got five minutes? Get more out of Toad with these short video tutorials. They are divided into the following categories:
You may need to disable your browser pop-up blocking to view the demos.
Posted: 10/08/2008
The Master/Detail Browser can be used to view or edit data from multiple tables, snapshots, views or queries linked by foreign keys or a user-defined master-detail relationship. This is typical of a database setup from an Entity/Relationship diagram, where one table's objects are related to another table's objects by a linking field or fields. If you have DBA privileges, you can view other schema's data as well as the one where you are logged in.
This video will show you how you can use Toad to format and review your code to specific standards.
The Code Road Map graphically displays the complex PL/SQL interdependencies within a database. You can think of the Code Road Map as a developer's model of the application code.
Posted: 07/18/2008
This is part of the "Discover the Hidden Treasures of Toad" series.
SQL Optimizer for Oracle allows you to:
This video provides a brief demonstration of SQL Optimizer for Oracle. Download the complementary PowerPoint presentation in PDF format.
Toad's Code Xpert tool is a quality assurance and standards enforcement tool for PL/SQL code that allows you to:
This video provides a brief demonstration of Code Xpert.
Posted: 05/01/2008
Toad for Oracle provides an interface to the Oracle Tuning Advisor. This feature is available from many locations within Toad.
This video will show you how to work with the Tuning Advisor using Toad for Oracle.
Posted: 03/27/2008
You can use Toad for Oracle to collect DBMS Profiler data and then view it as raw data or as a graph.
This video will demonstrate the basics of using the DBMS Line Item Profiler.
This video will demonstrate the basics of using the DBMS Hierarchical Profiler.
Posted: 06/27/2007
With SQL comparison users can view examples of optimization techniques for SQL statements.
Posted: 05/14/2007
Toad for Oracle and Benchmark Factory make it easy to create Oracle trace files and replay them in a test database environment.
Posted: 04/16/2007
SQL Scanner is included with Toad for Oracle Xpert Edition. With SQL Scanner users can:
With SQL Inspector users can:
SQL Optimizer is included with Toad for Oracle Xpert Edition. With SQL Optimizer users can:
Posted: 03/20/2008
This video will demonstrate how to run basic PL/SQL debugging functionality from within the Toad for Oracle editor window.
Toad for Oracle automates most debugging tasks, saving time and improving overall code quality. The Toad debugger:
Posted: 09/26/2008
This video demonstrates sharing actions be email and scheduling them using Windows Task Scheduler.
This video demonstrates how to use Actions directly from the various Toad for Oracle features rather than the Action Palette.
Actions are a powerful way to control database tasks you do over and over again. Features that are "actionable" allow you to save settings and run them at the click of a mouse. You can tweak settings before running, and you can string several actions together to automate an entire task.
This video will introduce the Action Palette and Action Recall features of Toad for Oracle.
Toad's Action Recall feature allows you to:
This video provides a brief demonstration of the Action Recall feature.
Posted: 10/10/2008
You can use Toad to manage your User Accounts, Roles, and Privileges. The Schema Browser provides easy access for creating and maintaining users.
The Log Switch Frequency screen shows when your database performs a log switch. Many DBA's aim to size their redo logs so that there are few log switches per hour. Frequent log switches can dramatically decrease performance, and infrequent log switches can increase database startup times. You can use this window to judge the balance of log switches.