[Home] [Help] [Dependency Information]
Object Name: | DBA_TYPE_ATTRS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of attributes of all types in the database
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Yes | Owner of the type |
TYPE_NAME | VARCHAR2 | (128) | Yes | Name of the type |
ATTR_NAME | VARCHAR2 | (128) | Yes | Name of the attribute |
ATTR_TYPE_MOD | VARCHAR2 | (7) | Type modifier of the attribute | |
ATTR_TYPE_OWNER | VARCHAR2 | (128) | Owner of the type of the attribute | |
ATTR_TYPE_NAME | VARCHAR2 | (128) | Name of the type of the attribute | |
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 | Yes | 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) | |
INHERITED | VARCHAR2 | (3) | Is the attribute inherited from the supertype ? |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TYPE_NAME
, ATTR_NAME
, ATTR_TYPE_MOD
, ATTR_TYPE_OWNER
, ATTR_TYPE_NAME
, LENGTH
, PRECISION
, SCALE
, CHARACTER_SET_NAME
, ATTR_NO
, INHERITED
FROM SYS.DBA_TYPE_ATTRS;
|
|
|