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
SQL Editor
|
31
Both commands return all the data from the specified object
in updateable mode. The red gem display, indicating “Read
Only”, changes to a green gem, meaning that you are now in
Updateable mode. The Data Edit buttons (“Insert a row”,
“Delete a row”, “Post data changes”, and “Revert data
changes”) on the SQL Edit toolbar also become active while
the data grid is in updateable mode.
Use the Toad Describe facility
The Toad Describe facility opens an extended Describe for
Oracle database objects. It provides much more detailed out-
put than does the SQL*Plus DESCRIBE command.
The Toad Describe opens a multitabbed window that dis-
plays the schema name, column names, datatype, data,
grants, script, etc., for the described object. You can drag-
and-drop column name(s) into the SQL Editor from this win-
dow. Double-clicking on the column name generates a
comma-separated list. You can also check Oracle’s currently
enforced referential integrity, the current status of con-
straints and triggers, and the current data. In addition, you
can see the other Oracle objects (views, snapshots, proce-
dures, etc.) that use the described object by clicking the
appropriate tab.
Execute the Toad Describe facility by typing:
DESC objectname F9
The Toad Describe has a predefined shortcut key, F4, which
you can press while your cursor rests on the object name.
TIP
Toad Describe is actually the Object Details panel
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