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.
See Also:
"Oracle Database SQL Language Reference" for information about PL/SQL functions
Parent topic: Managing Database Objects with Object Browser
Create a function using Object Browser.
To create a function:
Parent topic: Managing Functions
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
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
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
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
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
Select a function from the Object Selection pane and click Drop.
To drop a function in Object Browser:
Parent topic: Managing Functions