Get all functions

get

/database/objects/functions/

Returns records where OBJECT_TYPE = 'FUNCTION' from DBA_PROCEDURES or ALL_PROCEDURES view depending on role at runtime. A client requires SQL Administrator or SQL Developer role to invoke this service.

Request

Query Parameters
  • The maximum number of records to return.
  • Filtering is the process of limiting a collection resource by using a per-request dynamic filter definition across multiple page resources, where each page contains a subset of items found in the complete collection. Filtering enables efficient traversal of large collections.
    Examples

There's no request body for this operation.

Back to Top

Response

Supported Media Types

200 Response

Description of all functions in the database.
Body ()
Root Schema : DatabaseObjectsFunctions
Type: object
Show Source
Nested Schema : items
Type: array
Show Source
Nested Schema : DatabaseObjectsFunctionsItem
Type: object
Describes a function available in the database, along with associated properties. The list of attributes may vary depending on database version.
Show Source
Nested Schema : LinkRelation
Type: object
Show Source
Back to Top