ODP.NET-Specific Schema Collection

Oracle Data Provider for .NET supports both the common schema collections described previously and the following Oracle-specific schema collections:

• Tables

• Columns

• Views

• XMLSchema

• Users

• Synonyms

• Sequences

• Functions

• Procedures

• ProcedureParameters

• Arguments

• Packages

• PackageBodies

• JavaClasses

• Indexes

• IndexColumns

• PrimaryKeys

• ForeignKeys

• ForeignKeyColumns

• UniqueKeys

Tables

Table A-6 lists the column name, data type, and description of the Tables Schema Schema Collection.

Table 6 Tables

Column Name	Data Type	Description
OWNER	String	Owner of the Table.
TABLE_NAME	String	Name of the Table.
TYPE	String	Type of Table, for example, System or User.

Columns

Table A-7 lists the column name, data type, and description of the Columns Schema Collection .

Table 7 Columns

ColumnName	Data Type	Description
OWNER	String	Owner of the table or view.
TABLE_NAME	String	Name of the table or view.
COLUMN_NAME	String	Name of the column.
ID	Decimal	Sequence number of the column as created.
DATATYPE	String	Data type of the column.
LENGTH	Decimal	Length of the column in bytes.
PRECISION	Decimal	Decimal precision for NUMBER data type; binary precision for FLOAT data type, null for all other data types.
Scale	Decimal	Digits to right of decimal point in a number.
NULLABLE	String	Specifies whether or not a column allows NULLs.
CHAR_USED	String	Indicates whether the column uses BYTE length semantics (B) or CHAR length semantics (C).
LengthInChars	Decimal	Length of the column in characters. This value only applies to CHAR, VARCHAR2, NCHAR, and NVARCHAR2.

Views

Table A-8 lists the column name, data type, and description of the Views Schema Collection.

Table 8 Views

Column Name	Data Type	Description
OWNER	String	Owner of the view.
VIEW_NAME	String	Name of the view.
TEXT_LENGTH	Decimal	Length of the view text.
TEXT	String	View text.
TYPE_TEXT_LENGTH	Decimal	Length of the type clause of the typed view.
TYPE_TEXT	String	Type clause of the typed view.
OID_TEXT_LENGTH	Decimal	Length of the WITH OID clause of the typed view.
OID_TEXT	String	WITH OID clause of the typed view.
VIEW_TYPE_OWNER	String	Owner of the view type if the view is a typed view.
VIEW_TYPE	String	Type of the view if the view is a typed view.
SUPERVIEW_NAME	String	Name of the superview. (Oracle9i or later)

XMLSchema

Table A-9 lists the column name, data type and description of the XMLSchema Schema Collection.

Note: This collection is only available with Oracle Database 10g and later.

Table 9 XMLSchema

Column Name	Data Type	Description
OWNER	String	Owner of the XML schema.
SCHEMA_URL	String	Schema URL of the XML schema.
LOCAL	String	Indicates whether the XML schema is local (YES) or global (NO).
SCHEMA	String	XML schema document.
INT_OBJNAME	String	Internal database object name for the schema.
QUAL_SCHEMA_URL	String	Fully qualified schema URL.
HIER_TYPE	String	Hierarchy type for the schema.

Users

Table A-10 lists the column name, data type and description of the Users Schema Collection.

Table 10 Users

Column Name	Data Type	Description
NAME	String	Name of the user.
ID	Decimal	ID number of the user.
CREATEDATE	DateTime	User creation date.

Synonyms

Table A-11 lists the column name, data type and description of the Synonyms Schema Collection.

Table 11 Synonyms

Column Name	Data Type	Description
OWNER	String	Owner of the synonym.
SYNONYM_NAME	String	Name of the synonym.
TABLE_OWNER	String	Owner of the object referenced by the synonym. Although the column is called TABLE_OWNER, the object owned is not necessarily a table. It can be any general object such as a view, sequence, stored procedure, synonym, and so on.
TABLE_NAME	String	Name of the object referenced by the synonym. Although the column is called TABLE_NAME, the object does not necessarily have to be a table. It can be any general object such as a view, sequence, stored procedure, synonym, and so on.
DB_LINK	String	Name of the database link referenced, if any.

Sequences

Table A-12 lists the column name, data type, and description of the Sequences Schema Collection.

Table 12 Sequences

Column Name	Data Type	Description
SEQUENCE_OWNER	String	Name of the owner of the sequence.
SEQUENCE_NAME	String	Sequence name.
MIN_VALUE	Decimal	Minimum value of the sequence.
MAX_VALUE	Decimal	Maximum value of the sequence.
INCREMENT_BY	Decimal	Value by which sequence is incremented.
CYCLE_FLAG	String	Indicates if sequence wraps around on reaching limit.
ORDER_FLAG	String	Indicates if sequence numbers are generated in order.
CACHE_SIZE	Decimal	Number of sequence numbers to cache.
LAST_NUMBER	Decimal	Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used.

Functions

Table A-13 lists the column name, data type, and description of the Functions Schema Collection.

Table 13 Functions

Column Name	Data Type	Description
OWNER	String	Owner of the function.
OBJECT_NAME	String	Name of the function.
SUBOBJECT_NAME	String	Name of the subobject (for example, partition).
OBJECT_ID	Decimal	Dictionary object number of the function.
DATA_OBJECT_ID	Decimal	Dictionary object number of the segment that contains the function.
CREATED	DateTime	Timestamp for the creation of the function.
LAST_DDL_TIME	DateTime	Timestamp for the last modification of the function resulting from a DDL statement (including grants and revokes).
TIMESTAMP	String	Timestamp for the specification of the function (character data).
STATUS	String	Status of the function (VALID, INVALID, or N/A).
TEMPORARY	String	Whether or not the function is temporary (the current session can see only data that it placed in this object itself).
GENERATED	String	Indicates whether the name of this function is system generated (Y) or not (N).
SECONDARY	String	Whether or not this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N).

Procedures

Table A-14 lists the column name, data type, and description of the Procedures Schema Collection.

Table 14 Procedures

Column Name	Data Type	Description
OWNER	String	Owner of the procedure.
OBJECT_NAME	String	Name of the procedure.
SUBOBJECT_NAME	String	Name of the subobject (for example, partition).
OBJECT_ID	Decimal	Dictionary object number of the procedure.
DATA_OBJECT_ID	Decimal	Dictionary object number of the segment that contains the procedure.
CREATED	DateTime	Timestamp for the creation of the procedure.
LAST_DDL_TIME	Decimal	Timestamp for the last modification of the procedure resulting from a DDL statement (including grants and revokes).
TIMESTAMP	String	Timestamp for the specification of the procedure (character data).
STATUS	String	Status of the procedure (VALID, INVALID, or N/A).
TEMPORARY	String	Whether or not the procedure is temporary (the current session can see only data that it placed in this object itself).
GENERATED	String	Indicates whether the name of this procedure is system generated (Y) or not (N).
SECONDARY	String	Whether or not this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N).

ProcedureParameters

Table A-15 lists the column name, data type and description of the ProcedureParameters Schema Collection.

Table 15 ProcedureParameters

Column Name	Data Type	Description
OWNER	String	Owner of the object.
OBJECT_NAME	String	Name of the procedure or function.
PACKAGE_NAME	String	Name of the package.
OBJECT_ID	Decimal	Object number of the object.
OVERLOAD	String	Indicates the nth overloading ordered by its appearance in the source; otherwise, it is NULL.
SUBPROGRAM_ID	Decimal	Subprogram id for the procedure or function
ARGUMENT_NAME	String	If the argument is a scalar type, then the argument name is the name of the argument. A null argument name is used to denote a function return value.
POSITION	Decimal	If DATA_LEVEL is zero, then this column holds the position of this item in the argument list, or zero for a function return value.
SEQUENCE	Decimal	Defines the sequential order of the argument. Argument sequence starts from 1.
DATA_LEVEL	Decimal	Nesting depth of the argument for composite types.
DATA_TYPE	String	Data type of the argument.
DEFAULT_VALUE	String	Default value for the argument.
DEFAULT_LENGTH	Decimal	Length of the default value for the argument.
IN_OUT	String	Direction of the argument: [IN] [OUT] [IN/OUT].
DATA_LENGTH	Decimal	Length of the column (in bytes).
DATA_PRECISION	Decimal	Length in decimal digits (NUMBER) or binary digits (FLOAT).
DATA_SCALE	Decimal	Digits to the right of the decimal point in a number.
RADIX	Decimal	Argument radix for a number.
CHARACTER_SET_NAME	String	Character set name for the argument.
TYPE_OWNER	String	Owner of the type of the argument.
TYPE_NAME	String	Name of the type of the argument. If the type is a package local type (that is, it is declared in a package specification), then this column displays the name of the package.
TYPE_SUBNAME	String	Displays the name of the type declared in the package identified in the TYPE_NAME column. Relevant only for package local types.
TYPE_LINK	String	Displays the database link that refers to the remote package. Relevant only for package local types when the package identified in the TYPE_NAME column is a remote package.
PLS_TYPE	String	For numeric arguments, the name of the PL/SQL type of the argument. Otherwise, Null.
CHAR_LENGTH	Decimal	Character limit for string data types.
CHAR_USED	String	Indicates whether the byte limit (B) or character limit (C) is official for the string.

Arguments

Table A-16 lists the column name, data type, and description of the Arguments Schema Collection.

Table 16 Arguments

Column Name	Data Type	Description
OWNER	String	Owner of the object.
PACKAGE_NAME	String	Name of the package.
OBJECT_NAME	String	Name of the procedure or function.
ARGUMENT_NAME	String	If the argument is a scalar type, then the argument name is the name of the argument. A null argument name is used to denote a function return value.
POSITION	Decimal	If DATA_LEVEL is zero, then this column holds the position of this item in the argument list, or zero for a function return value.
SEQUENCE	Decimal	Defines the sequential order of the argument. Argument sequence starts from 1.
DEFAULT_VALUE	String	Default value for the argument.
DEFAULT_LENGTH	Decimal	Length of the default value for the argument.
IN_OUT	String	Direction of the argument: [IN] [OUT] [IN/OUT].
DATA_LENGTH	Decimal	Length of the column (in bytes).
DATA_PRECISION	Decimal	Length in decimal digits (NUMBER) or binary digits (FLOAT).
DATA_SCALE	Decimal	Digits to the right of the decimal point in a number.
DATA_TYPE	String	Data type of the argument.
CHAR_USED	String	Indicates whether the column uses BYTE length semantics (B) or CHAR length semantics (C).

Packages

Table A-17 lists the column name, data type, and description of the Packages Schema Collection.

Table 17 Packages

Column Name	Data Type	Description
OWNER	String	Owner of the package.
OBJECT_NAME	String	Name of the package.
SUBOBJECT_NAME	String	Name of the subobject (for example, partition).
OBJECT_ID	Decimal	Dictionary object number of the package.
DATA_OBJECT_ID	Decimal	Dictionary object number of the segment that contains the package.
CREATED	DateTime	Timestamp for the creation of the package.
LAST_DDL_TIME	DateTime	Timestamp for the last modification of the package resulting from a DDL statement (including grants and revokes).
TIMESTAMP	String	Timestamp for the specification of the package (character data).
STATUS	String	Status of the package (VALID, INVALID, or N/A).
TEMPORARY	String	Whether or not the package is temporary (the current session can see only data that it placed in this object itself).
GENERATED	String	Indicates whether the name of this package was system generated (Y) or not (N).
SECONDARY	String	Whether or not this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N).

PackageBodies

Table A-18 lists the column name, data type, and description of the PackageBodies Schema Collection.

Table 18 PackageBodies

Column Name	Data Type	Description
OWNER	String	Owner of the package body.
OBJECT_NAME	String	Name of the package body.
SUBOBJECT_NAME	String	Name of the subobject (for example, partition).
OBJECT_ID	Decimal	Dictionary object number of the package body.
DATA_OBJECT_ID	Decimal	Dictionary object number of the segment that contains the package body.
CREATED	DateTime	Timestamp for the creation of the package body.
LAST_DDL_TIME	DateTime	Timestamp for the last modification of the package body resulting from a DDL statement (including grants and revokes).
TIMESTAMP	String	Timestamp for the specification of the package body (character data).
STATUS	String	Status of the package body (VALID, INVALID, or N/A).
TEMPORARY	String	Whether the package body is temporary (the current session can see only data that it placed in this object itself).
GENERATED	String	Indicates whether the name of this package body is system generated (Y) or not (N).
SECONDARY	String	Whether or not this is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y | N).

JavaClasses

Table A-19 lists the column name, data type, and description of the JavaClasses Schema Collection.

Table 19 JavaClasses

Column Name	Data Type	Description
OWNER	String	Owner of the Java class.
NAME	String	Name of the Java class.
MAJOR	Decimal	Major version number of the Java class, as defined in the JVM specification.
MINOR	Decimal	Minor version number of the Java class, as defined in the JVM specification.
KIND	String	Indicates whether the stored object is a Java class (CLASS) or a Java interface (INTERFACE).
ACCESSIBILITY	String	Accessibility of the Java class.
IS_INNER	String	Indicates whether this Java class is an inner class (YES) or not (NO).
IS_ABSTRACT	String	Indicates whether this Java class is an abstract class (YES) or not (NO).
IS_FINAL	String	Indicates whether this Java class is a final class (YES) or not (NO).
IS_DEBUG	String	Indicates whether this Java class contains debug information (YES) or not (NO).
SOURCE	String	Source designation of the Java class.
SUPER	String	Super class of this Java class.
OUTER	String	Outer class of this Java class if this Java class is an inner class.

Indexes

Table A-20 lists the column name, data type, and description of the Indexes Schema Collection.

Table 20 Indexes

Column Name	Data Type	Description
OWNER	String	Owner of the index.
INDEX_NAME	String	Name of the index.
INDEX_TYPE	String	Type of the index: NORMAL BITMAP FUNCTION-BASED NORMAL FUNCTION-BASED BITMAP DOMAIN
TABLE_OWNER	String	Owner of the indexed object.
TABLE_NAME	String	Name of the indexed object.
TABLE_TYPE	String	Type of the indexed object (for example, TABLE or CLUSTER).
UNIQUENESS	String	Indicates whether the index is UNIQUE or NONUNIQUE.
COMPRESSION	String	Indicates whether index compression is enabled (ENABLED) or not (DISABLED).
PREFIX_LENGTH	Decimal	Number of columns in the prefix of the compression key.
TABLESPACE_NAME	String	Name of the tablespace containing the index.
INI_TRANS	Decimal	Initial number of transactions.
MAX_TRANS	Decimal	Maximum number of transactions.
INITIAL_EXTENT	Decimal	Size of the initial extent.
NEXT_EXTENT	Decimal	Size of secondary extents.
MIN_EXTENTS	Decimal	Minimum number of extents allowed in the segment.
MAX_EXTENTS	Decimal	Maximum number of extents allowed in the segment.
PCT_INCREASE	Decimal	Percentage increase in extent size.
PCT_THRESHOLD	Decimal	Threshold percentage of block space allowed per index entry.
INCLUDE_COLUMN	Decimal	Column ID of the last column to be included in index-organized table primary key (non-overflow) index. This column maps to the COLUMN_ID column of the *_TAB_COLUMNS data dictionary views.
FREELISTS	Decimal	Number of process freelists allocated to this segment.
FREELIST_GROUPS	Decimal	Number of freelist groups allocated to this segment.
PCT_FREE	Decimal	Minimum percentage of free space in a block.
LOGGING	String	Logging information.
BLEVEL	Decimal	B*-Tree level: depth of the index from its root block to its leaf blocks. A depth of 0 indicates that the root block and leaf block are the same.
LEAF_BLOCKS	Decimal	Number of leaf blocks in the index.
DISTINCT_KEYS	Decimal	Number of distinct indexed values. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is the same as the number of rows in the table (USER_TABLES.NUM_ROWS).
AVG_LEAF_BLOCKS_PER_KEY	Decimal	Average number of leaf blocks in which each distinct value in the index appears, rounded to the nearest integer. For indexes that enforce UNIQUE and PRIMARY KEY constraints, this value is always 1.
AVG_DATA_BLOCKS_PER_KEY	Decimal	Average number of data blocks in the table that are pointed to by a distinct value in the index, rounded to the nearest integer. This statistic is the average number of data blocks that contain rows that contain a given value for the indexed columns.
CLUSTERING_FACTOR	Decimal	Indicates the amount of order of the rows in the table based on the values of the index.
STATUS	String	Indicates whether a nonpartitioned index is VALID or UNUSABLE.
NUM_ROWS	Decimal	Number of rows in the index.
SAMPLE_SIZE	Decimal	Size of the sample used to analyze the index.
LAST_ANALYZED	Date	Date on which this index was most recently analyzed.
DEGREE	String	Number of threads per instance for scanning the index.
INSTANCES	String	Number of instances across which the indexes to be scanned.
PARTITIONED	String	Indicates whether the index is partitioned (YES) or not (NO).
TEMPORARY	String	Indicates whether or not the index is on a temporary table.
GENERATED	String	Indicates whether the name of the index is system generated (Y) or not (N).
SECONDARY	String	Indicates whether the index is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y) or not (N).
BUFFER_POOL	String	Name of the default buffer pool to be used for the index blocks.
USER_STATS	String	Indicates whether statistics were entered directly by the user (YES) or not (NO).
DURATION	String	Indicates the duration of a temporary table.
PCT_DIRECT_ACCESS	Decimal	For a secondary index on an index-organized table, the percentage of rows with VALID guess.
ITYP_OWNER	String	For a domain index, the owner of the index type.
ITYP_NAME	String	For a domain index, the name of the index type.
PARAMETERS	String	For a domain index, the parameter string.
GLOBAL_STATS	String	For partitioned indexes, indicates whether statistics are collected by analyzing the index as a whole (YES) or estimated from statistics on underlying index partitions and subpartitions (NO).
DOMIDX_STATUS	String	Status of the domain index: NULL - Index is not a domain index. VALID - Index is a valid domain index. IDXTYP_INVLD - Indextype of the domain index is invalid.
DOMIDX_OPSTATUS	String	Status of the operation on the domain index: NULL - Index is not a domain index. VALID - Operation performed without errors. FAILED - Operation failed with an error.
FUNCIDX_STATUS	String	Status of a function-based index: NULL - Index is not a function-based index. ENABLED - Function-based index is enabled. DISABLED - Function-based index is disabled.
JOIN_INDEX	String	Indicates whether the index is a join index (YES) or not (NO).
IOT_REDUNDANT_PKEY_ELIM	String	Indicates whether redundant primary key columns are eliminated from secondary indexes on index-organized tables (YES) or not (NO).
DROPPED	String	Indicates whether the index has been dropped and is in the recycle bin (YES) or not (NO); null for partitioned tables.

IndexColumns

Table A-21 lists the column name, data type, and description of the IndexColumns Schema Collection.

Table 21 IndexColumns

Column Name	Data Type	Description
INDEX_OWNER	String	Owner of the index.
INDEX_NAME	String	Name of the index.
TABLE_OWNER	String	Owner of the table or cluster.
TABLE_NAME	String	Name of the table or cluster.
COLUMN_NAME	String	Column name or attribute of object type column.
COLUMN_POSITION	Decimal	Position of column or attribute within the index.
COLUMN_LENGTH	Decimal	Indexed length of the column.
DESCEND	String	Whether the column is sorted in descending order (Y/N).
CHAR_LENGTH	Decimal	Maximum codepoint length of the column. (Oracle9i or later)

PrimaryKeys

Table A-22 lists the column name, data type, and description of the PrimaryKeys Schema Collection.

Table 22 PrimaryKeys

Column Name	Data Type	Description
OWNER	String	Owner of the constraint definition.
CONSTRAINT_NAME	String	Name of the constraint definition.
TABLE_NAME	String	Name associated with the table (or view) with constraint definition.
SEARCH_CONDITION	String	Text of search condition for a check constraint.
R_OWNER	String	Owner of table referred to in a referential constraint.
R_CONSTRAINT_NAME	String	Name of the unique constraint definition for referenced table.
DELETE_RULE	String	Delete rule for a referential constraint (CASCADE or NO ACTION).
STATUS	String	Enforcement status of constraint (ENABLED or DISABLED).
DEFERRABLE	String	Whether or not the constraint is deferrable.
VALIDATED	String	Whether all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATED	String	Whether the name of the constraint is user or system generated.
BAD	String	Indicates that this constraint specifies a century in an ambiguous manner. (Yes| No) To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.
RELY	String	Whether an enabled constraint is enforced or unenforced.
LAST_CHANGE	DateTime	When the constraint was last enabled or disabled.
INDEX_OWNER	String	Name of the user owning the index. (Oracle9i or later)
INDEX_NAME	String	Name of the index (only shown for unique and primary-key constraints). (Oracle9i or later)

ForeignKeys

Table A-23 lists the column name, data type, and description of the ForeignKeys Schema Collection.

Table 23 ForeignKeys

Column Name	Data Type	Description
PRIMARY_KEY_CONSTRAINT_NAME	String	Name of the constraint definition.
PRIMARY_KEY_OWNER	String	Owner of the constraint definition.
PRIMARY_KEY_TABLE_NAME	String	Name associated with the table (or view) with constraint definition.
FOREIGN_KEY_OWNER	String	Owner of the constraint definition.
FOREIGN_KEY_CONSTRAINT_NAME	String	Name of the constraint definition.
FOREIGN_KEY_TABLE_NAME	String	Name associated with the table (or view) with constraint definition.
SEARCH_CONDITION	String	Text of search condition for a check constraint
R_OWNER	String	Owner of table referred to, in a referential constraint.
R_CONSTRAINT_NAME	String	Name of the unique constraint definition for referenced table.
DELETE_RULE	String	Delete rule for a referential constraint (CASCADE or NO ACTION).
STATUS	String	Enforcement status of constraint (ENABLED or DISABLED).
VALIDATED	String	Whether or not all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATED	String	Whether the name of the constraint is user or system generated.
RELY	String	Whether an enabled constraint is enforced or unenforced.
LAST_CHANGE	DateTime	When the constraint was last enabled or disabled.
INDEX_OWNER	String	Name of the user owning the index. (Oracle9i or later)
INDEX_NAME	String	Name of the index. (Oracle9i or later)

ForeignKeyColumns

Table A-24 lists the column name, data type, and description of the ForeignKeyColumns Schema Collection.

Table 24 ForeignKeyColumns

Column Name	Data Type	Description
OWNER	String	Owner of the constraint definition.
CONSTRAINT_NAME	String	Name of the constraint definition.
TABLE_NAME	String	Name of the table with constraint definition.
COLUMN_NAME	String	Name of the column or attribute of the object type column specified in the constraint definition.
POSITION	String	Original position of column or attribute in the definition of the object.

UniqueKeys

Table A-25 lists the column name, data type, and description of the UniqueKeys Schema Collection.

Table 25 UniqueKeys

Column Name	Data Type	Description
OWNER	String	Owner of the constraint definition.
CONSTRAINT_NAME	String	Name of the constraint definition.
TABLE_NAME	String	Name associated with the table (or view) with constraint definition.
SEARCH_CONDITION	String	Text of search condition for a check constraint.
R_OWNER	String	Owner of table referred to in a referential constraint.
R_CONSTRAINT_NAME	String	Name of the unique constraint definition for referenced table.
DELETE_RULE	String	Delete rule for a referential constraint (CASCADE or NO ACTION).
STATUS	String	Enforcement status of constraint (ENABLED or DISABLED).
DEFERRABLE	String	Whether or not the constraint is deferrable.
VALIDATED	String	Whether all data obeys the constraint (VALIDATED or NOT VALIDATED).
GENERATED	String	Whether the name of the constraint is user or system generated.
BAD	String	Indicates that this constraint specifies a century in an ambiguous manner. (Yes| No) To avoid errors resulting from this ambiguity, rewrite the constraint using the TO_DATE function with a four-digit year.
RELY	String	Whether an enabled constraint is enforced or not.
LAST_CHANGE	String	When the constraint was last enabled or disabled.
INDEX_OWNER	String	Name of the user owning the index. (Oracle9i or later)
INDEX_NAME	String	Name of the index (only shown for unique and primary-key constraints). (Oracle9i or later)