© 2018 Quest Software Inc. ALL RIGHTS RESERVED.
This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software Inc.
The information in this document is provided in connection with Quest Software products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest Software products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST SOFTWARE ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST SOFTWARE BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST SOFTWARE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest Software makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest Software does not make any commitment to update the information contained in this document.
If you have any questions regarding your potential use of this material, contact:
Quest Software Inc.
Attn: LEGAL Dept
4 Polaris Way
Aliso Viejo, CA 92656
Refer to our Web site (https://www.quest.com) for regional and international office information.
Quest Software is proud of our advanced technology. Patents and pending patents may apply to this product. For the most current information about applicable patents for this product, please visit our website at https://www.quest.com/legal.
Quest, the Quest logo, and Join the Innovation are trademarks and registered trademarks of Quest Software Inc. For a complete list of Quest marks, visit https://www.quest.com/legal/trademark-information.aspx. All other trademarks and registered trademarks are property of their respective owners.
Toad for Oracle Getting Started
Updated - 4/17/2018
Version - 13.0
Table of Contents
Welcome to Toad
Welcome to Toad™ for Oracle®
Toad for Oracle provides an intuitive and efficient way for database professionals of all skill and experience levels to perform their jobs with an overall improvement in workflow effectiveness and productivity. With Toad for Oracle you can:
- Understand your database environment through visual representations
- Meet deadlines easily through automation and smooth workflows
- Perform essential development and administration tasks from a single tool
- Deploy high-quality applications that meet user requirements; perform predictably and reliably in production
- Validate database code to ensure the best-possible performance and adherence to best-practice standards
- Manage and share projects, templates, scripts, and more with ease
The Toad for Oracle solutions are built for you, by you. Over 15 years of development and feedback from various communities like Toad World have made it the most powerful and functional tool available. With an installed-base of over two million, Toad for Oracle continues to be one of the most preferred tools for database development and administration.
It is important to note that Toad for Oracle will only let you do what your DBA has granted you the rights to do via direct privilege grants or indirectly through roles. Toad does not circumvent, augment or otherwise defy your Oracle database security settings. If the DBA does not grant you the CREATE TABLE privilege, then the Create Table in Toad will not work. Likewise If the DBA does not grant you the CREATE PROCEDURE privilege, then the PL/SQL Editor in Toad will be severely limited. You will not be able to compile procedures, functions or packages. Toad only allows you to do what your DBA has permitted you to do.
About This Guide
The goal of this guide is to help you start using Toad quickly by learning basic features and tasks. Toad is a very diverse and powerful tool, and there are many features not covered here. In many cases, a feature may be introduced in this guide, with further instructions to see the online help. Refer to the online help for thorough documentation on all Toad functionality. You can access the help at any time by pressing F1. You can:
- Use the Table of Contents to get an outline view of all the components of Toad and links to the related documentation. You can also go directly to this page by clicking Help | Contents.
- Use the Search tool to find topics based on keywords that you input.
- Use the Favorites tab to bookmark topics to which you refer frequently.