oracle.jdbc.driver.oracledatabasemetadata.html

Oracle JDBC 的javaDoc

	<a href="#getTypeInfo()"><b>getTypeInfo</b></a>()
  <dd> Get a description of all the standard SQL types supported by
this database.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#getUDTs(java.lang.String, java.lang.String, java.lang.String, int[])"><b>getUDTs</b></a>(String, String, String, int[])
  <dd> Implements JDBC 2.0 DatabaseMetaData::getUDTs.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#getURL()"><b>getURL</b></a>()
  <dd> What's the url for this database?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#getUserName()"><b>getUserName</b></a>()
  <dd> What's our user name as known to the database?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#getVersionColumns(java.lang.String, java.lang.String, java.lang.String)"><b>getVersionColumns</b></a>(String, String, String)
  <dd> Get a description of a table's columns that are automatically
updated when any value in a row is updated.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#insertsAreDetected(int)"><b>insertsAreDetected</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.insertsAreDetected.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#isCatalogAtStart()"><b>isCatalogAtStart</b></a>()
  <dd> Does a catalog appear at the start of a qualified table name?
(Otherwise it appears at the end)


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#isReadOnly()"><b>isReadOnly</b></a>()
  <dd> Is the database in read-only mode?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#nullPlusNonNullIsNull()"><b>nullPlusNonNullIsNull</b></a>()
  <dd> Are concatenations between NULL and non-NULL values NULL?

A JDBC compliant driver always returns true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#nullsAreSortedAtEnd()"><b>nullsAreSortedAtEnd</b></a>()
  <dd> Are NULL values sorted at the end regardless of sort order?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#nullsAreSortedAtStart()"><b>nullsAreSortedAtStart</b></a>()
  <dd> Are NULL values sorted at the start regardless of sort order?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#nullsAreSortedHigh()"><b>nullsAreSortedHigh</b></a>()
  <dd> Are NULL values sorted high?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#nullsAreSortedLow()"><b>nullsAreSortedLow</b></a>()
  <dd> Are NULL values sorted low?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#othersDeletesAreVisible(int)"><b>othersDeletesAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData..
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#othersInsertsAreVisible(int)"><b>othersInsertsAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.othersInsertsAreVisible.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#othersUpdatesAreVisible(int)"><b>othersUpdatesAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData..
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#ownDeletesAreVisible(int)"><b>ownDeletesAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.ownDeletesAreVisible.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#ownInsertsAreVisible(int)"><b>ownInsertsAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.ownInsertsAreVisible.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#ownUpdatesAreVisible(int)"><b>ownUpdatesAreVisible</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.ownUpdatesAreVisible.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesLowerCaseIdentifiers()"><b>storesLowerCaseIdentifiers</b></a>()
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in lower case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesLowerCaseQuotedIdentifiers()"><b>storesLowerCaseQuotedIdentifiers</b></a>()
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in lower case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesMixedCaseIdentifiers()"><b>storesMixedCaseIdentifiers</b></a>()
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in mixed case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesMixedCaseQuotedIdentifiers()"><b>storesMixedCaseQuotedIdentifiers</b></a>()
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in mixed case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesUpperCaseIdentifiers()"><b>storesUpperCaseIdentifiers</b></a>()
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in upper case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#storesUpperCaseQuotedIdentifiers()"><b>storesUpperCaseQuotedIdentifiers</b></a>()
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in upper case?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsAlterTableWithAddColumn()"><b>supportsAlterTableWithAddColumn</b></a>()
  <dd> Is "ALTER TABLE" with add column supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsAlterTableWithDropColumn()"><b>supportsAlterTableWithDropColumn</b></a>()
  <dd> Is "ALTER TABLE" with drop column supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsANSI92EntryLevelSQL()"><b>supportsANSI92EntryLevelSQL</b></a>()
  <dd> Is the ANSI92 entry level SQL grammar supported?

All JDBC compliant drivers must return true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsANSI92FullSQL()"><b>supportsANSI92FullSQL</b></a>()
  <dd> Is the ANSI92 full SQL grammar supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsANSI92IntermediateSQL()"><b>supportsANSI92IntermediateSQL</b></a>()
  <dd> Is the ANSI92 intermediate SQL grammar supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsBatchUpdates()"><b>supportsBatchUpdates</b></a>()
  <dd> Implements JDBC 2.0 DatabaseMetaData::supportBatchUpdates.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCatalogsInDataManipulation()"><b>supportsCatalogsInDataManipulation</b></a>()
  <dd> Can a catalog name be used in a data manipulation statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCatalogsInIndexDefinitions()"><b>supportsCatalogsInIndexDefinitions</b></a>()
  <dd> Can a catalog name be used in a index definition statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCatalogsInPrivilegeDefinitions()"><b>supportsCatalogsInPrivilegeDefinitions</b></a>()
  <dd> Can a catalog name be used in a privilege definition statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCatalogsInProcedureCalls()"><b>supportsCatalogsInProcedureCalls</b></a>()
  <dd> Can a catalog name be used in a procedure call statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCatalogsInTableDefinitions()"><b>supportsCatalogsInTableDefinitions</b></a>()
  <dd> Can a catalog name be used in a table definition statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsColumnAliasing()"><b>supportsColumnAliasing</b></a>()
  <dd> Is column aliasing supported? 

<P>If so, the SQL AS clause can be used to provide names for
computed columns or to provide alias names for columns as
required.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsConvert()"><b>supportsConvert</b></a>()
  <dd> Is the CONVERT function between SQL types supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsConvert(int, int)"><b>supportsConvert</b></a>(int, int)
  <dd> Is CONVERT between the given SQL types supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCoreSQLGrammar()"><b>supportsCoreSQLGrammar</b></a>()
  <dd> Is the ODBC Core SQL grammar supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsCorrelatedSubqueries()"><b>supportsCorrelatedSubqueries</b></a>()
  <dd> Are correlated subqueries supported?

A JDBC compliant driver always returns true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsDataDefinitionAndDataManipulationTransactions()"><b>supportsDataDefinitionAndDataManipulationTransactions</b></a>()
  <dd> Are both data definition and data manipulation statements
within a transaction supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsDataManipulationTransactionsOnly()"><b>supportsDataManipulationTransactionsOnly</b></a>()
  <dd> Are only data manipulation statements within a transaction
supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsDifferentTableCorrelationNames()"><b>supportsDifferentTableCorrelationNames</b></a>()
  <dd> If table correlation names are supported, are they restricted
to be different from the names of the tables?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsExpressionsInOrderBy()"><b>supportsExpressionsInOrderBy</b></a>()
  <dd> Are expressions in "ORDER BY" lists supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsExtendedSQLGrammar()"><b>supportsExtendedSQLGrammar</b></a>()
  <dd> Is the ODBC Extended SQL grammar supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsFullOuterJoins()"><b>supportsFullOuterJoins</b></a>()
  <dd> Are full nested outer joins supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsGroupBy()"><b>supportsGroupBy</b></a>()
  <dd> Is some form of "GROUP BY" clause supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsGroupByBeyondSelect()"><b>supportsGroupByBeyondSelect</b></a>()
  <dd> Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsGroupByUnrelated()"><b>supportsGroupByUnrelated</b></a>()
  <dd> Can a "GROUP BY" clause use columns not in the SELECT?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsIntegrityEnhancementFacility()"><b>supportsIntegrityEnhancementFacility</b></a>()
  <dd> Is the SQL Integrity Enhancement Facility supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsLikeEscapeClause()"><b>supportsLikeEscapeClause</b></a>()
  <dd> Is the escape character in "LIKE" clauses supported?

A JDBC compliant driver always returns true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsLimitedOuterJoins()"><b>supportsLimitedOuterJoins</b></a>()
  <dd> Is there limited support for outer joins?  (This will be true
if supportFullOuterJoins is true.)


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsMinimumSQLGrammar()"><b>supportsMinimumSQLGrammar</b></a>()
  <dd> Is the ODBC Minimum SQL grammar supported?

All JDBC compliant drivers must return true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsMixedCaseIdentifiers()"><b>supportsMixedCaseIdentifiers</b></a>()
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case sensitive and as a result store them in mixed case?

A JDBC compliant driver will always return false.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsMixedCaseQuotedIdentifiers()"><b>supportsMixedCaseQuotedIdentifiers</b></a>()
  <dd> Does the database treat mixed case quoted SQL identifiers as
case sensitive and as a result store them in mixed case?

A JDBC compliant driver will always return false.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsMultipleResultSets()"><b>supportsMultipleResultSets</b></a>()
  <dd> Are multiple ResultSets from a single execute supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsMultipleTransactions()"><b>supportsMultipleTransactions</b></a>()
  <dd> Can we have multiple transactions open at once (on different
connections)?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsNonNullableColumns()"><b>supportsNonNullableColumns</b></a>()
  <dd> Can columns be defined as non-nullable?

A JDBC compliant driver always returns true.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOpenCursorsAcrossCommit()"><b>supportsOpenCursorsAcrossCommit</b></a>()
  <dd> Can cursors remain open across commits?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOpenCursorsAcrossRollback()"><b>supportsOpenCursorsAcrossRollback</b></a>()
  <dd> Can cursors remain open across rollbacks?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOpenStatementsAcrossCommit()"><b>supportsOpenStatementsAcrossCommit</b></a>()
  <dd> Can statements remain open across commits?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOpenStatementsAcrossRollback()"><b>supportsOpenStatementsAcrossRollback</b></a>()
  <dd> Can statements remain open across rollbacks?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOrderByUnrelated()"><b>supportsOrderByUnrelated</b></a>()
  <dd> Can an "ORDER BY" clause use columns not in the SELECT?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsOuterJoins()"><b>supportsOuterJoins</b></a>()
  <dd> Is some form of outer join supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsPositionedDelete()"><b>supportsPositionedDelete</b></a>()
  <dd> Is positioned DELETE supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsPositionedUpdate()"><b>supportsPositionedUpdate</b></a>()
  <dd> Is positioned UPDATE supported?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsResultSetConcurrency(int, int)"><b>supportsResultSetConcurrency</b></a>(int, int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.supportsResultSetConcurrency.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsResultSetType(int)"><b>supportsResultSetType</b></a>(int)
  <dd> Implements JDBC 2.0 DatabaseMetaData.supportsResultSetType.
  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">
	<a href="#supportsSchemasInDataManipulation()"><b>supportsSchemasInDataManipulation</b></a>()
  <dd> Can a schema name be used in a data manipulation statement?


  <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">