
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