Remerciez-le!

Remerciez @Admin pour avoir partagé cet document gratuitement, de la manière la plus simple, en partageant sur les réseaux sociaux.

Toad users guide USER ? S GUIDE CThis guide contains proprietary information which is protected by copyright The information in this guide is subject to change without notice and does not represent a commitment on the part of Quest Software The software d

USER ? S GUIDE CThis guide contains proprietary information which is protected by copyright The information in this guide is subject to change without notice and does not represent a commitment on the part of Quest Software The software described in this guide is furnished under a license or nondisclosure agreement This software may be used or copied only in accordance with the terms of this 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 ? Quest Software Inc All Rights Reserved Quest is a trademark of Quest Software Inc Quest Software Inc Irvine Center Drive Irvine CA USA Tel - - Fax - - support quest com info quest com www quest com TOAD is a trademark of Quest Software Inc Other trademarks and registered trademarks used in this guide are the property of their respective owners CContents CONTENTS TOAD User ? s Guide INTRODUCTION LOGON LOGOFF LOGON OPTIONS CONNECTING TO PERSONAL ORACLE END CONNECTION SCHEMA PREPARATION BASIC NAVIGATION MOUSE KEYBOARD HOTKEYS ?? ADDING ALTERING RIGHT-CLICK MENUS Location of Right-Click Menus MAIN TOAD WINDOW TOOLBAR SQL EDITOR TOOLBAR BUTTONS SHORTCUT KEYS USING THE SQL EDITOR Selecting a table to edit Commit Explain Plan O ine Text Editor Recall and Add SQL OPTIONS FOR THE SQL EDITOR EXECUTING STATEMENTS Execute SQL Scripts Table View Aliases CONFIGURING THE EDITOR EDITOR OPTIONS General Options Highlighting Key Assignments C TOAD User ? s Guide Auto Replace Code Templates RIGHT-CLICK MENU SQL RESULTS GRID Results Grid Right-Click Menu OPTIONS FOR THE DATA GRIDS LONG AND LONG RAW TIME VALUES SQL TEMPLATES DBMSOUTPUT TO DEBUG PL SQL CODE MAKE CODE STATEMENT AND STRIP CODE STATEMENT OPTIONS FOR THE EDITORS SQL EDITOR TASKS PROCEDURE EDITOR TOOLBAR BUTTONS SHORTCUT KEYS USING THE PROCEDURE EDITOR NAVIGATOR LIST Navigator buttons OPTIONS FOR THE PROCEDURE EDITOR RIGHT-CLICK MENU SOURCE CODE MANAGEMENT PROCEDURE EDITOR TASKS PL SQL DEBUGGER REQUIREMENTS To run the PL SQL Debugger To Activate the PL SQL Debugger Registration Key DEBUG TOOLBAR BUTTONS DEBUG SHORTCUT KEYS USING THE DEBUGGER THE STATUS PANEL INDICATORS OPTIONS MENU FOR DEBUGGING THE DOCKABLE WINDOWS Breakpoints Watches Call Stack DBMSOUTPUT DEBUG FUNCTIONS PREPARING PL SQL CODE FOR PRODUCTION SCHEMA BROWSER TOOLBARS RIGHT-CLICK MENUS CContents USING THE SCHEMA BROWSER OPTIONS FOR THE SCHEMA BROWSER TABLES INDEXES PROCEDURES TRIGGERS SEQUENCES VIEWS SYNONYMS CONSTRAINTS DB LINKS JAVA SCHEMA BROWSER TASKS OTHER TOAD OPTIONS AND FEATURES SQL MODELER OBJECT SEARCH DDL REPORTS MASTER DETAIL RECORD BROWSER PRIVILEGES REBUILD TABLE TOAD SECURITY VIEW MENU OPTIONS MENU General Options Oracle Options Startup Options Files Options Source Control Options Printing Options TUNING SERVER STATISTICS SGA TRACE OPTIMIZATION ESTIMATE TABLE SIZE ESTIMATE INDEX SIZE PROFILER ANALYSIS ORACLE I ONLY OBJECT BROWSER ORACLE OR I ONLY Objects Panel Details Panel TROUBLESHOOTING FREQUENTLY ASKED QUESTIONS SQL NET NET INSTALLATION PROBLEMS UPGRADES TOAD ADD-ON MODULES C TOAD User ?