SQL Function Lookup

The SQL Editor provides function lookup for the various languages it supports. Function lookup can be used via the function lookup icon, the control/command L keyboard combination, or the Code -> Function Lookup menu option.

The function lookup works by determining a list of functions based on the current language type in the editor and then displaying them in a selectable list. For example, SQL function lookup would display the SQL aggregate functions. PL/SQL function lookup would display all of the PL/SQL functions like UPPER, DBMS_OUTPUT, etc. The Java function lookup would display methods pertaining to the class type of the variable on which the user is doing the lookup.