oracle.jdbc.driver.oracledatabasemetadata.html

Oracle JDBC 的javaDoc

 public boolean storesUpperCaseIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in upper case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="storesLowerCaseIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="storesLowerCaseIdentifiers"><b>storesLowerCaseIdentifiers</b></a>
<pre>
 public boolean storesLowerCaseIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in lower case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="storesMixedCaseIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="storesMixedCaseIdentifiers"><b>storesMixedCaseIdentifiers</b></a>
<pre>
 public boolean storesMixedCaseIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in mixed case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsMixedCaseQuotedIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsMixedCaseQuotedIdentifiers"><b>supportsMixedCaseQuotedIdentifiers</b></a>
<pre>
 public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
</pre>
<dl>
  <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.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="storesUpperCaseQuotedIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="storesUpperCaseQuotedIdentifiers"><b>storesUpperCaseQuotedIdentifiers</b></a>
<pre>
 public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in upper case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="storesLowerCaseQuotedIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="storesLowerCaseQuotedIdentifiers"><b>storesLowerCaseQuotedIdentifiers</b></a>
<pre>
 public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in lower case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="storesMixedCaseQuotedIdentifiers()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="storesMixedCaseQuotedIdentifiers"><b>storesMixedCaseQuotedIdentifiers</b></a>
<pre>
 public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
</pre>
<dl>
  <dd> Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in mixed case?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="getIdentifierQuoteString()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getIdentifierQuoteString"><b>getIdentifierQuoteString</b></a>
<pre>
 public String getIdentifierQuoteString() throws SQLException
</pre>
<dl>
  <dd> What's the string used to quote SQL identifiers?
This returns a space " " if identifier quoting isn't supported.
A JDBC compliant driver always uses a double quote character.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the quoting string
  </dl></dd>
</dl>
<a name="getSQLKeywords()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSQLKeywords"><b>getSQLKeywords</b></a>
<pre>
 public String getSQLKeywords() throws SQLException
</pre>
<dl>
  <dd> Get a comma separated list of all a database's SQL keywords
that are NOT also SQL92 keywords.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the list
  </dl></dd>
</dl>
<a name="getNumericFunctions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getNumericFunctions"><b>getNumericFunctions</b></a>
<pre>
 public String getNumericFunctions() throws SQLException
</pre>
<dl>
  <dd> Get a comma separated list of math functions.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the list
  </dl></dd>
</dl>
<a name="getStringFunctions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getStringFunctions"><b>getStringFunctions</b></a>
<pre>
 public String getStringFunctions() throws SQLException
</pre>
<dl>
  <dd> Get a comma separated list of string functions.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the list
  </dl></dd>
</dl>
<a name="getSystemFunctions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSystemFunctions"><b>getSystemFunctions</b></a>
<pre>
 public String getSystemFunctions() throws SQLException
</pre>
<dl>
  <dd> Get a comma separated list of system functions.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the list
  </dl></dd>
</dl>
<a name="getTimeDateFunctions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getTimeDateFunctions"><b>getTimeDateFunctions</b></a>
<pre>
 public String getTimeDateFunctions() throws SQLException
</pre>
<dl>
  <dd> Get a comma separated list of time and date functions.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the list
  </dl></dd>
</dl>
<a name="getSearchStringEscape()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSearchStringEscape"><b>getSearchStringEscape</b></a>
<pre>
 public String getSearchStringEscape() throws SQLException
</pre>
<dl>
  <dd> This is the string that can be used to escape '_' or '%' in
the string pattern style catalog search parameters.
<P>The '_' character represents any single character.
<P>The '%' character represents any sequence of zero or 
more characters.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the string used to escape wildcard characters
  </dl></dd>
</dl>
<a name="getExtraNameCharacters()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getExtraNameCharacters"><b>getExtraNameCharacters</b></a>
<pre>
 public String getExtraNameCharacters() throws SQLException
</pre>
<dl>
  <dd> Get all the "extra" characters that can be used in unquoted
identifier names (those beyond a-z, 0-9 and _).
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the string containing the extra characters
  </dl></dd>
</dl>
<a name="supportsAlterTableWithAddColumn()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsAlterTableWithAddColumn"><b>supportsAlterTableWithAddColumn</b></a>
<pre>
 public boolean supportsAlterTableWithAddColumn() throws SQLException
</pre>
<dl>
  <dd> Is "ALTER TABLE" with add column supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsAlterTableWithDropColumn()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsAlterTableWithDropColumn"><b>supportsAlterTableWithDropColumn</b></a>
<pre>
 public boolean supportsAlterTableWithDropColumn() throws SQLException
</pre>
<dl>
  <dd> Is "ALTER TABLE" with drop column supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsColumnAliasing()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsColumnAliasing"><b>supportsColumnAliasing</b></a>
<pre>
 public boolean supportsColumnAliasing() throws SQLException
</pre>
<dl>
  <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.
A JDBC compliant driver always returns true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="nullPlusNonNullIsNull()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="nullPlusNonNullIsNull"><b>nullPlusNonNullIsNull</b></a>
<pre>
 public boolean nullPlusNonNullIsNull() throws SQLException
</pre>
<dl>
  <dd> Are concatenations between NULL and non-NULL values NULL?
A JDBC compliant driver always returns true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsConvert()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsConvert"><b>supportsConvert</b></a>
<pre>
 public boolean supportsConvert() throws SQLException
</pre>
<dl>
  <dd> Is the CONVERT function between SQL types supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsConvert(int, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsConvert"><b>supportsConvert</b></a>
<pre>
 public boolean supportsConvert(int fromType,
                                int toType) throws SQLException
</pre>
<dl>
  <dd> Is CONVERT between the given SQL types supported?
<p>
  <dd><dl>
    <dt> <b>Parameters:</b>
    <dd> fromType - the type to convert from
    <dd> toType - the type to convert to
    <dt> <b>Returns:</b>
    <dd> true if so
    <dt> <b>See Also:</b>
    <dd> Types
  </dl></dd>
</dl>
<a name="supportsTableCorrelationNames()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsTableCorrelationNames"><b>supportsTableCorrelationNames</b></a>
<pre>
 public boolean supportsTableCorrelationNames() throws SQLException
</pre>
<dl>
  <dd> Are table correlation names supported?
A JDBC compliant driver always returns true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsDifferentTableCorrelationNames()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsDifferentTableCorrelationNames"><b>supportsDifferentTableCorrelationNames</b></a>
<pre>
 public boolean supportsDifferentTableCorrelationNames() throws SQLException
</pre>
<dl>
  <dd> If table correlation names are supported, are they restricted
to be different from the names of the tables?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsExpressionsInOrderBy()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsExpressionsInOrderBy"><b>supportsExpressionsInOrderBy</b></a>
<pre>
 public boolean supportsExpressionsInOrderBy() throws SQLException
</pre>
<dl>
  <dd> Are expressions in "ORDER BY" lists supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsOrderByUnrelated()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsOrderByUnrelated"><b>supportsOrderByUnrelated</b></a>
<pre>
 public boolean supportsOrderByUnrelated() throws SQLException
</pre>