[Home] [Help] [Dependency Information]
Object Name: | CDB_PLSQL_TYPE_ATTRS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of attributes of all plsql types in the database in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (30) | Owner of the type | |
TYPE_NAME | VARCHAR2 | (136) | Name of the type | |
PACKAGE_NAME | VARCHAR2 | (30) | Name of the package containing the type | |
ATTR_NAME | VARCHAR2 | (128) | Name of the attribute | |
ATTR_TYPE_MOD | VARCHAR2 | (7) | Type modifier of the attribute | |
ATTR_TYPE_OWNER | VARCHAR2 | (30) | Owner of the type of the attribute | |
ATTR_TYPE_NAME | VARCHAR2 | (136) | Name of the type of the attribute | |
ATTR_TYPE_PACKAGE | VARCHAR2 | (30) | Name of the package containing the attribute type | |
LENGTH | NUMBER | Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute | ||
PRECISION | NUMBER | Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute | ||
SCALE | NUMBER | Scale of the NUMBER or DECIMAL attribute | ||
CHARACTER_SET_NAME | VARCHAR2 | (44) | Character set name of the attribute | |
ATTR_NO | NUMBER | Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number) | ||
CHAR_USED | VARCHAR2 | (1) | ||
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TYPE_NAME
, PACKAGE_NAME
, ATTR_NAME
, ATTR_TYPE_MOD
, ATTR_TYPE_OWNER
, ATTR_TYPE_NAME
, ATTR_TYPE_PACKAGE
, LENGTH
, PRECISION
, SCALE
, CHARACTER_SET_NAME
, ATTR_NO
, CHAR_USED
, CON_ID
FROM SYS.CDB_PLSQL_TYPE_ATTRS;
SYS.CDB_PLSQL_TYPE_ATTRS does not reference any database object
SYS.CDB_PLSQL_TYPE_ATTRS is referenced by following:
|
|
|