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
54
|
Toad Pocket Reference for Oracle
Use NOPARALLEL hint in data grids
Uses the NOPARALLEL hint in the data grids, making
the queries consume less of Oracle’s resources when dis-
playing data from tables that have parallelism.
Objects Panel
As mentioned previously, the lefthand side (LHS) of the
Schema Browser displays the Objects panel (an example is
shown in Figure 11). When you specify an object type in the
Tab/Dropdown/Treeview selector, the Schema Browser lists
all of the objects of that type for the schema selected. The
Schema Browser defaults to the login schema for the current
session.
Toad checks your Oracle version and displays or suppresses
Schema Browser tabs accordingly. For instance, the Schema
Browser does not attempt to report on policies or libraries
when connected to an Oracle 7.x database (which does not
support such objects).
The Schema Browser lets you create, alter, copy, drop,
export, enable, disable, compile, and perform a variety of
other actions on the objects you select. Note, however, that
the current Oracle privileges of the logged-in user determine
which actions you are allowed to perform. These privileges
also affect your ability to display and alter objects owned by
other schemas.
An Oracle schema could be composed of many thousands of
objects per object type. The Schema Browser allows you to
filter the objects list in the Objects panel using the Filter but-
ton on the LHS ...
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