2.10 Managing Functions
A function is a subprogram that can take parameters and return a single value. You can use Object Browser to create, browse, edit, compile, download, drop functions and view report.
- Creating a Function
Create a function using Object Browser. - Browsing a Function
Select a function from the Object Selection pane and view different reports about the function. - Reports for Functions
Alternative views available when browsing a function in Object Browser. - Editing a Function Manually
Select a function from the Object Selection pane and click Edit. - Compiling a Function
Select a function from the Object Selection pane click Save & Compile. - Downloading a Function
Select a function from the Object Selection pane click Download Source to save the current function as a file. - Dropping a Function
Select a function from the Object Selection pane and click Drop.
See Also:
-
"Oracle Database SQL Language Reference" for information about PL/SQL functions
Parent topic: Managing Database Objects with Object Browser
2.10.1 Creating a Function
Create a function using Object Browser.
To create a function:
Parent topic: Managing Functions
2.10.2 Browsing a Function
Select a function from the Object Selection pane and view different reports about the function.
To view a function in Object Browser:
See Also:
Parent topic: Managing Functions
2.10.3 Reports for Functions
Alternative views available when browsing a function in Object Browser.
Table 2-9 describes all available reports for functions.
Table 2-9 Available Reports for Functions
View | Description |
---|---|
Code |
(Default) Displays the source code for the function. You can edit the code in this view. Actions you can perform in this view include:
|
Dependencies |
Displays objects that use (or depend) on the current function and objects the function depends on. |
Errors |
Displays errors related to the current function. |
Grants |
Lists details of grants for the current function, including privilege, grantee, grantable, grantor, and object name. |
See Also:
Parent topic: Managing Functions
2.10.4 Editing a Function Manually
Select a function from the Object Selection pane and click Edit.
When you edit a function you can edit the code manually, perform a search and replace, and compile the function.
Parent topic: Managing Functions
2.10.5 Compiling a Function
Select a function from the Object Selection pane click Save & Compile.
If you edit and make changes to a function, you must compile to save your changes. There is no save function because this is just a view of the object within the database.
To compile a function in Object Browser:
Parent topic: Managing Functions
2.10.6 Downloading a Function
Select a function from the Object Selection pane click Download Source to save the current function as a file.
To save a function to a file in Object Browser:
Parent topic: Managing Functions
2.10.7 Dropping a Function
Select a function from the Object Selection pane and click Drop.
To drop a function in Object Browser:
Parent topic: Managing Functions