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
90
|
Toad Pocket Reference for Oracle
Creating and Altering Objects
Toad’s Create and Alter dialogs help DBAs to manage their
database objects. For example, you can quickly create a roll-
back segment from Toad’s Create menu or from the Roll-
back Segments Schema Browser tab. This section describes
objects you can manage if the DBA Module is present.
Create new objects
You can use the Create dialog available from the Create
menu to quickly create a database object without having to
worry about syntax or typographical errors.
The Create/Alter dialogs are fully fleshed out to display all of
the DDL options supported by Oracle (options not available
and activated are greyed out). The dialogs are smart enough
to detect the Oracle version you are connected to and to
enable/disable the appropriate options. Figure 20 shows a
portion of the menu invoked by selecting DBA
Create.
If you have a role in one instance, you can use the handy
Schema Browser function, Create Like, to create the same
role in another instance. You can even modify the script that
will be executed if you want to tweak the role you are moving.
Alter existing objects
You can use Toad’s Alter dialogs to make a change to an
existing object. You can access these directly from the
Schema Browser or, if you are querying an object in an edi-
tor and you need to modify or examine the object(s) at hand,
you can simply place your cursor on the object ...
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