EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation


A stored function (also called a user function or user-defined function) is a set of PL/SQL statements you can call by name. Stored functions are very similar to procedures, except that a function returns a value to the environment in which it is called. User functions can be used as part of a SQL expression.


Function Editor allows you to define function properties. It opens automatically when you create a new function and is available on editing an existing one.


To open a function in Function Editor, double-click it in the DB Explorer tree.


See also:

Using PL/SQL Code Debugger