Remerciez-le!

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

SQL Navigator® 7.6 User Guide Copyright 2019 Quest Software Inc. ALL RIGHTS RES

SQL Navigator® 7.6 User Guide Copyright 2019 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 (www.quest.com) for regional and international office information. Patents 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 www.quest.com/legal. Trademarks Quest, Toad, Toad World, SQL Navigator, Benchmark Factory and the Quest logo are trademarks and registered trademarks of Quest Software Inc. For a complete list of Quest marks, visit www.quest.com/legal. All other trademarks and registered trademarks are property of their respective owners. Legend CAUTION: A CAUTION icon indicates potential damage to hardware or loss of data if instructions are not followed. WARNING: A WARNING icon indicates a potential for property damage, personal injury, or death. IMPORTANT NOTE, NOTE, TIP, MOBILE, or VIDEO: An information icon indicates supporting information. SQL Navigator User Guide Updated - December 2019 Software Version - 7.6 Contents Quick Overview 14 Better code, faster. 14 Who should use SQL Navigator? 14 Enter A New Authorization Key 14 Check for Updates 15 Working With SQL Navigator 16 Oracle Sessions 16 Finding Objects 16 Working With Objects 17 Web Development 18 Java Source Code 19 Analysis And Tuning 19 Team Coding And Version Control 20 Navigation 21 Main Menu 21 File Menu 21 Edit Menu 22 Search Menu 24 View Menu 24 Session Menu 26 Object Menu 27 Tools Menu 30 Team Coding Menu 33 Help Menu 34 Task Bar 35 Toolbars 35 Component List 36 Connection Category Color 40 Main Menu Keyboard Shortcuts 41 Customize The Screen Layout 43 Float / Dock 43 Toolbars in the Main Window 44 Main Menu Bar 44 Oracle Logon 45 SQL Navigator 7.6 User Guide 3 Oracle Logon Dialog 45 Oracle Client Settings 45 Connection Parameters 45 Username / Password 46 Options 47 Oracle TNS Configuration 47 Advanced Service Options Dialog 48 Address List Options Dialog 49 DBA Dictionary Views 49 How SQL Navigator handles the views 50 Troubleshooting Connections to Oracle 50 Command Line Parameters 51 Code Editor 52 SQL Development 52 PL/SQL Development 52 Toolbox 53 Code Editor SQL 53 General Code Editor Functions 53 SQL Specific Functions 54 Team Coding Version Control 56 Tools and Applications 57 Code Editor PL/SQL 58 General Code Editor Functions 58 PL/SQL Specific Functions 59 Team Coding Version Control 60 Tools and Applications 61 Edit, Compile And Execute 61 SQL*Plus command support 66 Executing Scripts Invoked By At Sign (@) or Double At Sign (@@) SQL*Plus Commands 67 Connect To A Database Via The Code Editor 67 Bind Variables 67 Auto Code Completion 68 Scan Defines/Substitutions 68 Specifying substitution variables in SQL statements 69 DEFINE and UNDEFINE 70 New Stored Object Dialog 70 SQL Statement CRUD Matrix Dialog 71 SQL Query Results 71 SQL Query Results Data Grid 71 SQL Navigator 7.6 User Guide 4 Rows Retrieved 72 Export / Print 72 Browse 73 Edit (Updateable Queries) 73 Group Display 74 Format 74 Sort & Display 74 SQL Query Log (The Spool Tab) 75 Export Data Dialog 75 Viewers: LOB, XML, Array 75 LOB Editor 75 ARRAY Editor 76 PL/SQL Execution Console 76 Run Time Parameters 77 Run Options 77 Code Test 78 PL/SQL Stub 79 DBMS_OUTPUT 79 Code Editor Keyboard Shortcuts 80 Right Click Over The Editing Pane 80 PL/SQL Debugger Keyboard Shortcuts 82 Further Shortcuts In The Code Editor Editing Pane 82 Further Shortcuts Viewing SQL Code Execution Results 83 Shortcuts In The Code Editor Toolbar 83 Toolbox 84 PL/SQL Debugger 84 Requirements 85 Debug 85 Code Explorer 86 Outline 87 DB Explorer 87 Describe 88 History 89 Dependencies 89 Columns 90 Visual Object Editors 91 Cluster Editor 92 Ways to Open The Cluster Editor 92 Constraint Editor 92 SQL Navigator 7.6 User Guide 5 Using The Editor 93 Steps To Create A Constraint 93 Now the constraint is defined 94 Ways to Open The Constraint Editor 94 Database Link Editor 95 Ways to Open The Database Link Editor 95 Index Editor 95 Ways to Open The Index Editor 96 Nested Table Editor 96 Profile Editor 97 Requirements 97 Ways to Open The Profile Editor 97 Redo Log Group Editor 97 Ways to Open The Redo Log Group Editor 98 Role Editor 98 Requirements 98 Ways to Open The Role Editor 99 Materialized View Editor 99 Using The Editor 99 Editor Toolbar 99 Editor Tabs 100 Ways to Open The Materialized View Editor 100 Sequence Editor 100 Ways to Open The Sequence Editor 101 Synonym Editor 101 Ways to Open The Synonym Editor 102 Table Editor 102 Ways to Open The Table Editor 102 User Editor 103 Requirements 103 Ways to Open The User Editor 103 Varray Editor 103 View Editor 104 Using The Editor 104 Editor Toolbar 104 Editor Tabs 105 Ways to Open The View Editor 105 Java Editor 105 Ways to open the Java Editor 106 SQL Navigator 7.6 User Guide 6 Instance Property Editor 106 Using The Editor 106 Instance Property 106 Editor Toolbar 107 Details Tab 107 Ways to Open The Instance Property Editor 108 Team Coding and Version Control Support 109 Use Team Coding with a VCS 109 Use Team Coding without a VCS 109 Work with non-controlled objects 110 Objects Supported by Team Coding 110 Administer Team Coding 110 Toolbar 111 Settings tab 111 Team Projects tab 111 Install Team Coding 111 Team Coding Settings 113 Team Projects 115 Setup Team Projects 116 Team Coding Roles 118 Configure Team Coding 119 Options 119 Configure Concurrent Version Systems (CVS) 120 Configure Git 122 Configure IBM Rational ClearCase 122 Configure Perforce (P4) 123 General tab 123 Options tab 123 Configure Serena PVCS Version Manager 124 Configure Subversion (SVN) 124 Client Tab 125 Server Defaults Tab 125 OptionsTab 125 Configure Microsoft Team Foundation Server 126 General Tab 126 Check In / Out Tab 126 History Tab 127 Advanced Tab 127 Team Coding Status 127 SQL Navigator 7.6 User Guide 7 Team Coding Manager 128 VCS tab 128 Team Projects tab 128 Work with Team Coding objects 129 Provider logon 131 Using Git 132 Using Perforce 132 Using IBM Rational ClearCase 132 Mapped Drive and Views 132 Check in and Check out 133 Check in/check out individual objects 133 Check in all items 133 Automatic Check In and Check Out 134 Undo a checkout 134 Version Control Systems 134 Direct Supported 134 SCC Support 136 Concurrent Version (CVS) System Requirements 136 More about Git and SQL Navigator 136 More about IBM Rational ClearCase and SQL Navigator 137 More about Perforce and SQL Navigator 137 More about Team Foundation Server and SQL Navigator 137 TFS Work Items 138 Modules, Windows And Dialogs 140 Analyze Tool 140 Collect Statistics 140 Validate Structure 141 List Chained Rows 141 Auto Describe Tool 141 Benchmark Factory 143 Bookmarks Dialog 143 Capture Web Output 143 Start Capturing Web Output 144 While Capturing Web Output 144 Change Logon Password 144 Code Analysis 144 Access to Code Analysis 145 Rules and Rule Sets 145 Code Analysis Metrics 145 SQL Navigator 7.6 User Guide 8 Code Analysis Window 146 Code Analysis Rule Sets 147 Create and Edit uploads/S4/ user-guide-sql-navigator-7-6.pdf