7.195 V$EDITIONABLE_TYPES
V$EDITIONABLE_TYPES
lists all the editionable types based on the current compatibility setting. The SELECT
privilege on V$EDITIONABLE_TYPES
will be granted to PUBLIC
.
The database compatibility setting will determine the set of editionable types.
With compatibility set to 11.2 or 12, this set includes FUNCTION, LIBRARY, PACKAGE, PACKAGE BODY, PROCEDURE, SYNONYM, TRIGGER, TYPE, TYPE BODY, and VIEW. With compatibility set to 12, the set will include these types as well as the SQL TRANSLATION PROFILE.
Column | Datatype | Description |
---|---|---|
|
|
The name of the type that is editionable |
|
|
The number of the type that is editionable |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
For more information about edition-based redefinitions, see Oracle Database Development Guide.