|
Oracle Fusion Middleware Java API Reference for Oracle Real-Time Decisions 11g Release 1 (11.1.1) E17787-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface DatabaseProviderMetaData
Field Summary | |
---|---|
static java.lang.String[] |
TABLE_TYPES |
Method Summary | |
---|---|
java.lang.String |
getCatalog() Get the catalog. |
StoredProcedureParameterInfo[] |
getProcedureParameters(java.lang.String procedureName) |
StoredProcedureParameterInfo[] |
getProcedureParameters(java.lang.String catalog, java.lang.String schema, java.lang.String procedureName) |
StoredProcedureInfo[] |
getProcedures(java.lang.String procedureNamePattern) Get a result set from which you can get the names of stored procedures. |
StoredProcedureInfo[] |
getProcedures(java.lang.String catalog, java.lang.String schema, java.lang.String procedureNamePattern) Get a result set from which you can get the names of stored procedures. |
ColumnInfo[] |
getTableColumns(java.lang.String tableName) Get a set of ColumnInfo objects for a given table. |
ColumnInfo[] |
getTableColumns(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) Get a set of ColumnInfo objects for a given table. |
TableInfo[] |
getTables(java.lang.String tableNamePattern, java.lang.String[] types) Get a result set from which you can get the names of tables or views. |
TableInfo[] |
getTables(java.lang.String catalog, java.lang.String schema, java.lang.String tableNamePattern, java.lang.String[] types) Get a result set from which you can get the names of tables or views. |
void |
setCatalog(java.lang.String catalog) Set the catalog. |
void |
setSchema(java.lang.String schema) Set the schema. |
Field Detail |
---|
static final java.lang.String[] TABLE_TYPES
Method Detail |
---|
TableInfo[] getTables(java.lang.String catalog, java.lang.String schema, java.lang.String tableNamePattern, java.lang.String[] types)
tablePattern
parameter is used to determine which names to return. A '%' is the wildcard. Hence, the pattern "T%" would return all names that start with a 'T'. Whether the pattern match is case sensitive or not is a function of the database. The types
parameter allows you to specify whether you want the names of tables, view, or both returned. If the array contains "TABLE", then names of tables are returned. If the array contains "VIEW", then the names of views are returned. A call to this function closes the result set returned by the previous call.catalog
- - the database catalogschema
- - the schematableNamePattern
- - the table name patterntypes
- - identifies whether names of tables, views, or both are returnedTableInfo[] getTables(java.lang.String tableNamePattern, java.lang.String[] types)
tablePattern
parameter is used to determine which names to return. A '%' is the wildcard. Hence, the pattern "T%" would return all names that start with a 'T'. Whether the pattern match is case sensitive or not is a function of the database. The types
parameter allows you to specify whether you want the names of tables, view, or both returned. If the array contains "TABLE", then names of tables are returned. If the array contains "VIEW", then the names of views are returned. A call to this function closes the result set returned by the previous call.tableNamePattern
- - the table name patterntypes
- - identifies whether names of tables, views, or both are returnedStoredProcedureInfo[] getProcedures(java.lang.String procedureNamePattern)
procedurePattern
parameter is used to determine which names to return. A '%' is the wildcard. Whether the pattern match is case sensitive or not is a function of the database.procedureNamePattern
-StoredProcedureInfo[] getProcedures(java.lang.String catalog, java.lang.String schema, java.lang.String procedureNamePattern)
procedurePattern
parameter is used to determine which names to return. A '%' is the wildcard. Whether the pattern match is case sensitive or not is a function of the database.procedureNamePattern
-catalog
- - the catalogschema
- - the schemaStoredProcedureParameterInfo[] getProcedureParameters(java.lang.String procedureName)
StoredProcedureParameterInfo[] getProcedureParameters(java.lang.String catalog, java.lang.String schema, java.lang.String procedureName)
ColumnInfo[] getTableColumns(java.lang.String tableName)
tableName
parameter is a full name and not a pattern. Also, the catalog and schema cannot be wildcarded, i.e. you can't make this call if you have called setCatalog(null) or setSchema(null). (Although you can pass a null for the catalog for Oracle.)tableName
-null
if the table does not exist.ColumnInfo[] getTableColumns(java.lang.String catalog, java.lang.String schema, java.lang.String tableName)
tableName
parameter is a full name and not a pattern. Also, the catalog and schema cannot be wildcarded, i.e. you can't make this call if you have called setCatalog(null) or setSchema(null). (Although you can pass a null for the catalog for Oracle.)catalog
-schema
-tableName
-null
if the table does not exist.void setCatalog(java.lang.String catalog)
null
value for the catalog means to use all catalogs, i.e. the catalog is not used to determine which table or view names to pick up.catalog
- - the catalog name or null
.java.lang.String getCatalog()
null
if the catalog is not defined.void setSchema(java.lang.String schema)
null
value for the schema means to use all catalogs, i.e. the schema is not used to determine which table or view names to pick up.schema
- - the schema name or null
.
|
Oracle Fusion Middleware Java API Reference for Oracle Real-Time Decisions 11g Release 1 (11.1.1) E17787-02 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |