BODY defines or implements the member methods defined in the type specification that was created with the "CREATE TYPE Statement".
For each method specified in a type specification for which you did not specify the
call_spec, you must specify a corresponding method body in the type body.
If you create a SQLJ object type, then specify it as a Java class.
Every member declaration in the
TYPE specification for an ADT must have a corresponding construct in the
To create or replace a type body in your schema, you must have the
TYPE or the
TYPE system privilege. To create a type in another user's schema, you must have the
TYPE system privilege. To replace a type in another user's schema, you must have the
TYPE system privilege.
See "call_spec ::=".
Re-creates the type body if it exists, and recompiles it.
Users who were granted privileges on the type body before it was redefined can still access the type body without being regranted the privileges.
You can use this clause to add member subprogram definitions to specifications added with the
[ EDITIONABLE | NONEDITIONABLE ]
If you do not specify this property, then the type body inherits
NONEDITIONABLE from the type specification. If you do specify this property, then it must match that of the type specification.
Name of the schema containing the type body. Default: your schema.
Name of an ADT.
The type of function or procedure subprogram associated with the type specification.
You must define a corresponding method name and optional parameter list in the type specification for each procedure or function declaration. For functions, you also must specify a return type.
A procedure or function subprogram declaration.
Indicates that the function can run from a parallel execution server of a parallel query operation. The function must not use session state, such as package variables, because those variables are not necessarily shared among the parallel execution servers. The
parallel_enable_cl_in_type can appear only once in the function.
Use the optional
BY clause only with a function that has a
CURSOR data type. This clause lets you define the partitioning of the inputs to the function from the
CURSOR argument. Partitioning the inputs to the function affects the way the query is parallelized when the function is used as a table function in the
FROM clause of the query.
Indicates that the data can be partitioned randomly among the parallel execution servers
You can partition weak cursor variable arguments to table functions only with
ANY, not with
RANGE or HASH
Partitions data into specified columns that are returned by the
CURSOR argument of the function.
streaming_cl_in_type lets you order or cluster the parallel processing.
BY indicates that the rows on a parallel execution server must be locally ordered and have the same key values as specified by the
expr identifies the
CURSOR parameter name of the table function on which partitioning was specified, and on whose columns you are specifying ordering or clustering for each slave in a parallel query execution.
Specifies direct-key partitioning, which is intended for table functions used when executing MapReduce workloads. The
column must be of data type
VALUE distributes row processing uniformly over the available reducers.
If the column has more reducer numbers than there are available reducers, then PL/SQL uses a modulus operation to map the reducer numbers in the column into the correct range.
When calculating the number of the reducer to process the corresponding row, PL/SQL treats a negative value as zero and rounds a positive fractional value to the nearest integer.
Oracle Database Data Cartridge Developer's Guide for information about using parallel table functions
A user-defined constructor subprogram declaration. The
RETURN clause of a constructor function must be
RESULT. This setting indicates that the most specific type of the value returned by the constructor function is the most specific type of the
SELF argument that was passed in to the constructor function.
"CREATE TYPE Statement" for a list of restrictions on user-defined functions
"Overloaded Subprograms" for information about overloading subprogram names
Oracle Database Object-Relational Developer's Guide for information about and examples of user-defined constructors
Declares items that are local to the procedure or function.
Procedure or function statements.
You can declare either one
MAP method or one
ORDER method, regardless of how many
STATIC methods you declare. If you declare either a
ORDER method, then you can compare object instances in SQL.
If you do not declare either method, then you can compare object instances only for equality or inequality. Instances of the same type definition are equal only if each pair of their corresponding attributes is equal.
Declares or implements a
MAP member function that returns the relative position of a given instance in the ordering of all instances of the object. A
MAP method is called implicitly and specifies an ordering of object instances by mapping them to values of a predefined scalar type. PL/SQL uses the ordering to evaluate Boolean expressions and to perform comparisons.
If the argument to the
MAP method is null, then the
MAP method returns null and the method is not invoked.
An type body can contain only one
MAP method, which must be a function. The
MAP function can have no arguments other than the implicit
ORDER member function that takes an instance of an object as an explicit argument and the implicit
SELF argument and returns either a negative integer, zero, or a positive integer, indicating that the implicit
SELF argument is less than, equal to, or greater than the explicit argument, respectively.
If either argument to the
ORDER method is null, then the
ORDER method returns null and the method is not invoked.
When instances of the same ADT definition are compared in an
BY clause, the database invokes the
An object specification can contain only one
ORDER method, which must be a function having the return type
Deprecated way of declaring a C method, supported only for backward compatibility. Oracle recommends that you use the