The Oracle DESCRIBE command reports the attributes, methods and arguments of an object type. The SQL Navigator Describe command works with more objects than does the SQL*Plus version of the command. You can describe not only procedures, functions, packages, synonyms, and object types, but also tables, indexes, clusters and objects.
Ways to open the Auto Describe Tool
From the View Menu |
|
From the Code Editor |
If the object is a text object (view, procedure, function, package or packaged procedure/function) and the Source Preview window is open then the object’s source is automatically previewed. |
|
TIP:
|
Tips to use the Auto Describe Tool
A quick way to construct a SELECT statement |
To drag column names into a Select statement
|
In the Code Editor |
To move the text cursor to the declaration of a variable (or Auto Describe it if it’s the name of an external database) press CTRL and point to the variable with the mouse. To return to the former position in the text, press Alt+Left Arrow. |
Describe Command or Auto Describe Tool
Use either the Describe command or the Auto Describe Tool to describe an object
View Menu | Auto Describe Tool |
Automatically see a description of any object you select. A dockable Describe window opens and stays on top of the application window. As you select various objects you will automatically see a description of the selected object in the Auto Describe window. |
Object menu | Describe |
Click the Describe command on the Object menu whenever needed. It opens a describe window for a single selected object and will not update automatically when you select another object. |
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center