Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
10
|
Toad Pocket Reference for Oracle
Toad Menu Toolbar
The Toad Menu toolbar (Figure 1) currently has 13 menus.
File
Provides functions to open, save, reopen, and compare
files; connect and test Toad connections to Oracle; per-
form FTP and network utility operations; execute scripts
via the Script Manager; and run an archive function to
zip files.
Edit
Provides both standard text-editing functions and Oracle-
specific functions (e.g., Columns Dropdown). This menu
works with all three Toad editors (SQL Editor, Procedure
Editor, and Text Editor), although the Oracle features are
disabled for the offline Text Editor.
Grid
Interacts with the Schema Browser
Table/View
Data tab and the SQL Editor Results Panel Data
tab. Provides functions for searching, filtering, printing,
and exporting the displayed data.
SQL Editor
Provides functions for executing, saving, and recalling
SQL statements, as well as functions to execute the SQL
window via SQL*Plus or the Quest Script Runner.
Create
Provides model dialog screens for creating Oracle objects
such as DB links, policies, jobs, materialized views, users,
resource plans, etc.
Figure 1. Toad Menu toolbar
Toad Basics
|
11
Database
Contains functions for opening the Schema Browser, the
SQL Editor, the SQL Modeler, the Procedure Editor, and
the Database Browser, as well
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079