Toad pocket reference for Oracle
Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more p...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing ; Sebastopol, California :
O'Reilly Media
[2005]
|
| Edición: | 2nd ed |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009649839506719 |
Tabla de Contenidos:
- Contents; Toad Pocket Reference for Oracle; Introduction; Contributors; Caveats; For Help with Toad; Conventions; Toad Basics; Installing and Configuring Toad; Expanding Toad's Functionality; Configuring External Tools; Toad Startup and Other Options; Toad Properties Files; Toad Menu Toolbar; Toad Toolbar Display; SQL Editor; Display; Toolbars and Menus; Main toolbar; Edit toolbar; Formatting toolbar; Script Debugging toolbar; Source Control toolbar; SQL Recall toolbar; Current Schema toolbar; SQL Editor menu; Edit menu; Right Mouse menu; Shortcut Keys; Supporting Other Parsers/Languages
- Working with Files in the SQL EditorOpen files; Integrated Source Control/Team Coding; Executing Statements; Execute a single statement; Execute all SQL; Execute a script; Execute SQL*Plus; Execute with ScriptRunner; Parse (Describe) a SELECT statement; Use substitution variables; Cancel running statement; Using Extended Features; Use the Script Debugger; Invoke SQL Command Recall; Display Object Palette (tables, views, synonyms, columns); Display code snippets; Change Active Sessions for this Window; Make a Non-SQL Code Statement/ Strip All Non-SQL Syntax; Use the EDIT command
- Use the Toad Describe facilityDisplay column dropdown; Use code templates; Format code; Add and remove comments; Data Grid; Manipulating the Display, not the Query; Sort data, rearrange columns, and filter data; Configure data grid options; Navigating the Grid; Scroll down; Scroll left to right; Editing Data from the Data Grid; Access the Single Record View; Saving/Sending Data in Various Formats; Schedule a Save As; Display Record Count from right mouse grid popup; Print Grid engine; Working with Data; Master Detail Browser; Compare Data wizard
- Import Table Data wizard (from text file or Excel)Table Data Duplicates window; SQL Optimization; Explain Plans; Explain Plan in the SQL Editor; Previous Explain Plan results; SQL Optimization Facilities; AutoTrace; SQL Trace (TKPROF); SGA Trace Optimization; Session Browser; Additional Tuning Methods; Schema Browser; Configuring the Schema Browser; Visual options; Behavioral and data-specific options; Objects Panel; Objects panel toolbar; Objects panel right mouse; Favorites tab; Details Panel; Schema Browser Tips and Tricks; Procedure Editor; Procedure Editor Options
- Configuring the Procedure EditorProcedure Editor Display; Procedure Editor Keys; Procedure Editor Menus and Toolbars; Procedure Edit toolbar; Debugger toolbar; Formatter toolbar; Right Mouse menu; Populating the Procedure Editor; Procedure Editor Shortcut Keys; Using the Procedure Editor; Customize Toad templates; Create output statements; Use Code Completion; Use DBMS_OUPUT package; Find closing block; Compile; Debugger; Setting Debugger Options; Debugger Menus and Toolbar; Output Panel; Breakpoints tab; Watches tab; DBMS Output tab; Call Stack tab; REF CURSOR Results tab; Setting Parameters
- Just-in-Time Debugging
