oracle.jdbc.driver.oracledatabasemetadata.html

Oracle JDBC 的javaDoc

<dl>
  <dd> Can an "ORDER BY" clause use columns not in the SELECT?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsGroupBy()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsGroupBy"><b>supportsGroupBy</b></a>
<pre>
 public boolean supportsGroupBy() throws SQLException
</pre>
<dl>
  <dd> Is some form of "GROUP BY" clause supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsGroupByUnrelated()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsGroupByUnrelated"><b>supportsGroupByUnrelated</b></a>
<pre>
 public boolean supportsGroupByUnrelated() throws SQLException
</pre>
<dl>
  <dd> Can a "GROUP BY" clause use columns not in the SELECT?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsGroupByBeyondSelect()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsGroupByBeyondSelect"><b>supportsGroupByBeyondSelect</b></a>
<pre>
 public boolean supportsGroupByBeyondSelect() throws SQLException
</pre>
<dl>
  <dd> Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsLikeEscapeClause()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsLikeEscapeClause"><b>supportsLikeEscapeClause</b></a>
<pre>
 public boolean supportsLikeEscapeClause() throws SQLException
</pre>
<dl>
  <dd> Is the escape character in "LIKE" clauses supported?
A JDBC compliant driver always returns true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsMultipleResultSets()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsMultipleResultSets"><b>supportsMultipleResultSets</b></a>
<pre>
 public boolean supportsMultipleResultSets() throws SQLException
</pre>
<dl>
  <dd> Are multiple ResultSets from a single execute supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsMultipleTransactions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsMultipleTransactions"><b>supportsMultipleTransactions</b></a>
<pre>
 public boolean supportsMultipleTransactions() throws SQLException
</pre>
<dl>
  <dd> Can we have multiple transactions open at once (on different
connections)?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsNonNullableColumns()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsNonNullableColumns"><b>supportsNonNullableColumns</b></a>
<pre>
 public boolean supportsNonNullableColumns() throws SQLException
</pre>
<dl>
  <dd> Can columns be defined as non-nullable?
A JDBC compliant driver always returns true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsMinimumSQLGrammar()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsMinimumSQLGrammar"><b>supportsMinimumSQLGrammar</b></a>
<pre>
 public boolean supportsMinimumSQLGrammar() throws SQLException
</pre>
<dl>
  <dd> Is the ODBC Minimum SQL grammar supported?
All JDBC compliant drivers must return true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsCoreSQLGrammar()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsCoreSQLGrammar"><b>supportsCoreSQLGrammar</b></a>
<pre>
 public boolean supportsCoreSQLGrammar() throws SQLException
</pre>
<dl>
  <dd> Is the ODBC Core SQL grammar supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsExtendedSQLGrammar()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsExtendedSQLGrammar"><b>supportsExtendedSQLGrammar</b></a>
<pre>
 public boolean supportsExtendedSQLGrammar() throws SQLException
</pre>
<dl>
  <dd> Is the ODBC Extended SQL grammar supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsANSI92EntryLevelSQL()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsANSI92EntryLevelSQL"><b>supportsANSI92EntryLevelSQL</b></a>
<pre>
 public boolean supportsANSI92EntryLevelSQL() throws SQLException
</pre>
<dl>
  <dd> Is the ANSI92 entry level SQL grammar supported?
All JDBC compliant drivers must return true.
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsANSI92IntermediateSQL()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsANSI92IntermediateSQL"><b>supportsANSI92IntermediateSQL</b></a>
<pre>
 public boolean supportsANSI92IntermediateSQL() throws SQLException
</pre>
<dl>
  <dd> Is the ANSI92 intermediate SQL grammar supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsANSI92FullSQL()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsANSI92FullSQL"><b>supportsANSI92FullSQL</b></a>
<pre>
 public boolean supportsANSI92FullSQL() throws SQLException
</pre>
<dl>
  <dd> Is the ANSI92 full SQL grammar supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsIntegrityEnhancementFacility()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsIntegrityEnhancementFacility"><b>supportsIntegrityEnhancementFacility</b></a>
<pre>
 public boolean supportsIntegrityEnhancementFacility() throws SQLException
</pre>
<dl>
  <dd> Is the SQL Integrity Enhancement Facility supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsOuterJoins()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsOuterJoins"><b>supportsOuterJoins</b></a>
<pre>
 public boolean supportsOuterJoins() throws SQLException
</pre>
<dl>
  <dd> Is some form of outer join supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsFullOuterJoins()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsFullOuterJoins"><b>supportsFullOuterJoins</b></a>
<pre>
 public boolean supportsFullOuterJoins() throws SQLException
</pre>
<dl>
  <dd> Are full nested outer joins supported?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsLimitedOuterJoins()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsLimitedOuterJoins"><b>supportsLimitedOuterJoins</b></a>
<pre>
 public boolean supportsLimitedOuterJoins() throws SQLException
</pre>
<dl>
  <dd> Is there limited support for outer joins?  (This will be true
if supportFullOuterJoins is true.)
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="getSchemaTerm()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getSchemaTerm"><b>getSchemaTerm</b></a>
<pre>
 public String getSchemaTerm() throws SQLException
</pre>
<dl>
  <dd> What's the database vendor's preferred term for "schema"?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the vendor term
  </dl></dd>
</dl>
<a name="getProcedureTerm()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getProcedureTerm"><b>getProcedureTerm</b></a>
<pre>
 public String getProcedureTerm() throws SQLException
</pre>
<dl>
  <dd> What's the database vendor's preferred term for "procedure"?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the vendor term
  </dl></dd>
</dl>
<a name="getCatalogTerm()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCatalogTerm"><b>getCatalogTerm</b></a>
<pre>
 public String getCatalogTerm() throws SQLException
</pre>
<dl>
  <dd> What's the database vendor's preferred term for "catalog"?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the vendor term
  </dl></dd>
</dl>
<a name="isCatalogAtStart()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="isCatalogAtStart"><b>isCatalogAtStart</b></a>
<pre>
 public boolean isCatalogAtStart() throws SQLException
</pre>
<dl>
  <dd> Does a catalog appear at the start of a qualified table name?
(Otherwise it appears at the end)
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if it appears at the start
  </dl></dd>
</dl>
<a name="getCatalogSeparator()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="getCatalogSeparator"><b>getCatalogSeparator</b></a>
<pre>
 public String getCatalogSeparator() throws SQLException
</pre>
<dl>
  <dd> What's the separator between catalog and table name?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> the separator string
  </dl></dd>
</dl>
<a name="supportsSchemasInDataManipulation()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsSchemasInDataManipulation"><b>supportsSchemasInDataManipulation</b></a>
<pre>
 public boolean supportsSchemasInDataManipulation() throws SQLException
</pre>
<dl>
  <dd> Can a schema name be used in a data manipulation statement?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsSchemasInProcedureCalls()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsSchemasInProcedureCalls"><b>supportsSchemasInProcedureCalls</b></a>
<pre>
 public boolean supportsSchemasInProcedureCalls() throws SQLException
</pre>
<dl>
  <dd> Can a schema name be used in a procedure call statement?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsSchemasInTableDefinitions()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a>
<a name="supportsSchemasInTableDefinitions"><b>supportsSchemasInTableDefinitions</b></a>
<pre>
 public boolean supportsSchemasInTableDefinitions() throws SQLException
</pre>
<dl>
  <dd> Can a schema name be used in a table definition statement?
<p>
  <dd><dl>
    <dt> <b>Returns:</b>
    <dd> true if so
  </dl></dd>
</dl>
<a name="supportsSchemasInIndexDefinitions()"><img src="images/red-ball.gif" width=