In the Stored Program editor, if you want to move the text cursor to the declaration of a variable (or Auto Describe it if it’s the name of an external database), just press Ctrl and point to the variable with the mouse. To return to the former position in the text, press Ctrl+Backspace.
Pointing to the variable while pressing Ctrl moves the cursor to the declaration
Pointing to the variable while pressing Ctrl moves the cursor to the declaration
To see a description of any object from within the Stored Program Editor, you can simply click the object’s name while holding down the Ctrl key. This will open an Auto Describe window for that object.
In addition, if the referenced 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.
Pointing to the object name while pressing Ctrl opens the Auto Describe window
