Online Documentation for SQL Manager for Oracle

Creating/editing function


Use the Function tab of Function Editor to create/edit a user-defined function and specify its properties.

 

Function Editor - Editing function definition

 

Name

Specify the name of the function to be created, or view the name of the function being edited. Note that the function name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the function will be created.

 

The lower area of the editor window allows you to specify the function definition. The DDL tab will display the changes made to the function specification.

 

For your convenience the code folding, syntax highlight, code completion and a number of other features for efficient SQL editing are implemented. For details see Working with Query data and Using the context menu.

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.