
Toad Pocket Reference for Oracle
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- Intro
- 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 Editor
- Open 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 facility
- Display 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 Editor
- Procedure 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
- Executing a Stored Program from the Debugger
- Executing a Stored Program Without Debugging
- After Debugging
- Code Profiling
- Using CodeXpert
- Results tree tab
- Summary Report tab
- CRUD Matrix tab
- Metrics Report tab
- CodeXpert toolbar
- Database Administration
- Using the DBA Module
- Additional functionality
- Knowledge Xpert for Oracle Administration
- Using the Database Browser
- Modifying Oracle Parameters
- Managing Sessions
- Top Session Finder
- Session Browser
- Creating and Altering Objects
- Create new objects
- Alter existing objects
- Managing Tablespaces
- Display tablespace statistics
- Display tablespace map
- Checking Extents
- Using Oracle's Import/Export Tools
- Export File Browser
- Using Other Toad Import/Export Utilities
- Comparing Schemas and Databases
- Performing SGA Trace Optimization
- Using the HTML Schema Doc Generator
- User Administration
- Managing Users
- Create User and Alter User
- Compare users
- Toad Security
- Managing Roles
- Configure Grantees
- Managing Resource Groups and Resource Plans
- Managing Policies and Policy Groups
- Auditing
- Audit SQL/SYS Privs
- Audit objects
- Project Manager
- Creating and Using Projects
- Customizing Project Manager's Behavior
- Saving and Sharing Project Files
- Project Manager Tips and Tricks
- Additional Toad Modules
- Toad for Oracle
- Toad for Oracle Professional Edition
- Toad for Oracle Xpert Edition
- Toad for Oracle Suite
- Toad-DBA Module
- DataFactoryT
- Benchmark Factory® for Oracle
- QDesignerT Physical Architect
- Index
System requirements
File format: PDF
Copy-Protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (only limited: Kindle).
The file format PDF always displays a book page identically on any hardware. This makes PDF suitable for complex layouts such as those used in textbooks and reference books (images, tables, columns, footnotes). Unfortunately, on the small screens of e-readers or smartphones, PDFs are rather annoying, requiring too much scrolling.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our eBook Help page.