DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_PLSQL_TYPE_ATTRS

Object Details
Object Name: DBA_PLSQL_TYPE_ATTRS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of attributes of all plsql types in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128)
Owner of the type
TYPE_NAME VARCHAR2 (136)
Name of the type
PACKAGE_NAME VARCHAR2 (128)
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 (128)
Owner of the type of the attribute
ATTR_TYPE_NAME VARCHAR2 (136)
Name of the type of the attribute
ATTR_TYPE_PACKAGE VARCHAR2 (128)
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)
Query Text

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
FROM SYS.DBA_PLSQL_TYPE_ATTRS;

Dependencies

[top of page]

SYS.DBA_PLSQL_TYPE_ATTRS references the following:

SchemaSYS
TableATTRIBUTE$
TableOID$
TableTYPE$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.DBA_PLSQL_TYPE_ATTRS is referenced by following:

SchemaPUBLIC
SynonymDBA_PLSQL_TYPE_ATTRS