📄 oracle.jdbc.driver.oracledatabasemetadata.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><!--NewPage--><html><head><!-- Generated by javadoc on Thu Dec 02 03:30:11 PST 1999 --><title> Class oracle.jdbc.driver.OracleDatabaseMetaData</title></head><body><a name="_top_"></a><pre><a href="packages.html">All Packages</a> <a href="tree.html">Class Hierarchy</a> <a href="Package-oracle.jdbc.driver.html">This Package</a> <a href="oracle.jdbc.driver.OracleConnection.html#_top_">Previous</a> <a href="oracle.jdbc.driver.OracleDriver.html#_top_">Next</a> <a href="AllNames.html">Index</a></pre><hr><h1> Class oracle.jdbc.driver.OracleDatabaseMetaData</h1><pre>java.lang.Object | +----oracle.jdbc.driver.OracleDatabaseMetaData</pre><hr><dl> <dt> public class <b>OracleDatabaseMetaData</b> <dt> extends Object <dt> implements DatabaseMetaData</dl>The OracleDatabaseMetaData class implements the JDBC 1.0 DatabaseMetaDatainterface.<p><hr><a name="index"></a><h2> <img src="images/constructor-index.gif" width=275 height=38 alt="Constructor Index"></h2><dl> <dt> <img src="images/yellow-ball-small.gif" width=6 height=6 alt=" o "> <a href="#OracleDatabaseMetaData(oracle.jdbc.driver.OracleConnection)"><b>OracleDatabaseMetaData</b></a>(OracleConnection) <dd> </dl><h2> <img src="images/method-index.gif" width=207 height=38 alt="Method Index"></h2><dl> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#allProceduresAreCallable()"><b>allProceduresAreCallable</b></a>() <dd> Can all the procedures returned by getProcedures be called by thecurrent user? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#allTablesAreSelectable()"><b>allTablesAreSelectable</b></a>() <dd> Can all the tables returned by getTable be SELECTed by thecurrent user? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#dataDefinitionCausesTransactionCommit()"><b>dataDefinitionCausesTransactionCommit</b></a>() <dd> Does a data definition statement within a transaction force thetransaction to commit? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#dataDefinitionIgnoredInTransactions()"><b>dataDefinitionIgnoredInTransactions</b></a>() <dd> Is a data definition statement within a transaction ignored? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#deletesAreDetected(int)"><b>deletesAreDetected</b></a>(int) <dd> Implements JDBC 2.0 DatabaseMetaData.deletesAreDetected. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#doesMaxRowSizeIncludeBlobs()"><b>doesMaxRowSizeIncludeBlobs</b></a>() <dd> Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARYblobs? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBestRowIdentifier(java.lang.String, java.lang.String, java.lang.String, int, boolean)"><b>getBestRowIdentifier</b></a>(String, String, String, int, boolean) <dd> Get a description of a table's optimal set of columns thatuniquely identifies a row. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCatalogs()"><b>getCatalogs</b></a>() <dd> Get the catalog names available in this database. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCatalogSeparator()"><b>getCatalogSeparator</b></a>() <dd> What's the separator between catalog and table name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCatalogTerm()"><b>getCatalogTerm</b></a>() <dd> What's the database vendor's preferred term for "catalog"? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getColumnPrivileges(java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><b>getColumnPrivileges</b></a>(String, String, String, String) <dd> Get a description of the access rights for a table's columns. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><b>getColumns</b></a>(String, String, String, String) <dd> Get a description of table columns available in a catalog. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getConnection()"><b>getConnection</b></a>() <dd> Implements JDBC 2.0 DatabaseMetaData.getConnection. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCrossReference(java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><b>getCrossReference</b></a>(String, String, String, String, String, String) <dd> Get a description of the foreign key columns in the foreign keytable that reference the primary key columns of the primary keytable (describe how one table imports another's key.) Thisshould normally return a single foreign key/primary key pair(most tables only import a foreign key from a table once.) Theyare ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, andKEY_SEQ. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDatabaseProductName()"><b>getDatabaseProductName</b></a>() <dd> What's the name of this database product? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDatabaseProductVersion()"><b>getDatabaseProductVersion</b></a>() <dd> What's the version of this database product? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDefaultTransactionIsolation()"><b>getDefaultTransactionIsolation</b></a>() <dd> What's the database's default transaction isolation level? Thevalues are defined in java.sql.Connection. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverMajorVersion()"><b>getDriverMajorVersion</b></a>() <dd> What's this JDBC driver's major version number? <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverMajorVersionInfo()"><b>getDriverMajorVersionInfo</b></a>() <dd> What's this JDBC driver's major version number? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverMinorVersion()"><b>getDriverMinorVersion</b></a>() <dd> What's this JDBC driver's minor version number? <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverMinorVersionInfo()"><b>getDriverMinorVersionInfo</b></a>() <dd> What's this JDBC driver's minor version number? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverName()"><b>getDriverName</b></a>() <dd> What's the name of this JDBC driver? <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverNameInfo()"><b>getDriverNameInfo</b></a>() <dd> What's the name of this JDBC driver? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverVersion()"><b>getDriverVersion</b></a>() <dd> What's the version of this JDBC driver? <dt> <img src="images/green-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDriverVersionInfo()"><b>getDriverVersionInfo</b></a>() <dd> What's the version of this JDBC driver? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getExportedKeys(java.lang.String, java.lang.String, java.lang.String)"><b>getExportedKeys</b></a>(String, String, String) <dd> Get a description of a foreign key columns that reference atable's primary key columns (the foreign keys exported by atable). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getExtraNameCharacters()"><b>getExtraNameCharacters</b></a>() <dd> Get all the "extra" characters that can be used in unquotedidentifier names (those beyond a-z, 0-9 and _). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getIdentifierQuoteString()"><b>getIdentifierQuoteString</b></a>() <dd> What's the string used to quote SQL identifiers?This returns a space " " if identifier quoting isn't supported. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getImportedKeys(java.lang.String, java.lang.String, java.lang.String)"><b>getImportedKeys</b></a>(String, String, String) <dd> Get a description of the primary key columns that arereferenced by a table's foreign key columns (the primary keysimported by a table). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getIndexInfo(java.lang.String, java.lang.String, java.lang.String, boolean, boolean)"><b>getIndexInfo</b></a>(String, String, String, boolean, boolean) <dd> Get a description of a table's indices and statistics. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxBinaryLiteralLength()"><b>getMaxBinaryLiteralLength</b></a>() <dd> How many hex characters can you have in an inline binary literal? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxCatalogNameLength()"><b>getMaxCatalogNameLength</b></a>() <dd> What's the maximum length of a catalog name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxCharLiteralLength()"><b>getMaxCharLiteralLength</b></a>() <dd> What's the max length for a character literal? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnNameLength()"><b>getMaxColumnNameLength</b></a>() <dd> What's the limit on column name length? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnsInGroupBy()"><b>getMaxColumnsInGroupBy</b></a>() <dd> What's the maximum number of columns in a "GROUP BY" clause? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnsInIndex()"><b>getMaxColumnsInIndex</b></a>() <dd> What's the maximum number of columns allowed in an index? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnsInOrderBy()"><b>getMaxColumnsInOrderBy</b></a>() <dd> What's the maximum number of columns in an "ORDER BY" clause? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnsInSelect()"><b>getMaxColumnsInSelect</b></a>() <dd> What's the maximum number of columns in a "SELECT" list? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxColumnsInTable()"><b>getMaxColumnsInTable</b></a>() <dd> What's maximum number of columns in a table? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxConnections()"><b>getMaxConnections</b></a>() <dd> How many active connections can we have at a time to this database? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxCursorNameLength()"><b>getMaxCursorNameLength</b></a>() <dd> What's the maximum cursor name length? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxIndexLength()"><b>getMaxIndexLength</b></a>() <dd> What's the maximum length of an index (in bytes)? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxProcedureNameLength()"><b>getMaxProcedureNameLength</b></a>() <dd> What's the maximum length of a procedure name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxRowSize()"><b>getMaxRowSize</b></a>() <dd> What's the maximum length of a single row? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxSchemaNameLength()"><b>getMaxSchemaNameLength</b></a>() <dd> What's the maximum length allowed for a schema name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxStatementLength()"><b>getMaxStatementLength</b></a>() <dd> What's the maximum length of a SQL statement? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxStatements()"><b>getMaxStatements</b></a>() <dd> How many active statements can we have open at one time to thisdatabase? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxTableNameLength()"><b>getMaxTableNameLength</b></a>() <dd> What's the maximum length of a table name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxTablesInSelect()"><b>getMaxTablesInSelect</b></a>() <dd> What's the maximum number of tables in a SELECT? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getMaxUserNameLength()"><b>getMaxUserNameLength</b></a>() <dd> What's the maximum length of a user name? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getNumericFunctions()"><b>getNumericFunctions</b></a>() <dd> Get a comma separated list of math functions. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getPrimaryKeys(java.lang.String, java.lang.String, java.lang.String)"><b>getPrimaryKeys</b></a>(String, String, String) <dd> Get a description of a table's primary key columns. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getProcedureColumns(java.lang.String, java.lang.String, java.lang.String, java.lang.String)"><b>getProcedureColumns</b></a>(String, String, String, String) <dd> Get a description of a catalog's stored procedure parametersand result columns. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getProcedures(java.lang.String, java.lang.String, java.lang.String)"><b>getProcedures</b></a>(String, String, String) <dd> Get a description of stored procedures available in acatalog. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getProcedureTerm()"><b>getProcedureTerm</b></a>() <dd> What's the database vendor's preferred term for "procedure"? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSchemas()"><b>getSchemas</b></a>() <dd> Get the schema names available in this database. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSchemaTerm()"><b>getSchemaTerm</b></a>() <dd> What's the database vendor's preferred term for "schema"? <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSearchStringEscape()"><b>getSearchStringEscape</b></a>() <dd> This is the string that can be used to escape '_' or '%' inthe string pattern style catalog search parameters. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSQLKeywords()"><b>getSQLKeywords</b></a>() <dd> Get a comma separated list of all a database's SQL keywordsthat are NOT also SQL92 keywords. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getStringFunctions()"><b>getStringFunctions</b></a>() <dd> Get a comma separated list of string functions. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSystemFunctions()"><b>getSystemFunctions</b></a>() <dd> Get a comma separated list of system functions. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTablePrivileges(java.lang.String, java.lang.String, java.lang.String)"><b>getTablePrivileges</b></a>(String, String, String) <dd> Get a description of the access rights for each table availablein a catalog. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTables(java.lang.String, java.lang.String, java.lang.String, java.lang.String[])"><b>getTables</b></a>(String, String, String, String[]) <dd> Get a description of tables available in a catalog. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTableTypes()"><b>getTableTypes</b></a>() <dd> Get the table types available in this database. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTimeDateFunctions()"><b>getTimeDateFunctions</b></a>() <dd> Get a comma separated list of time and date functions. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o ">⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -