|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.9.0) E52944-01 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface OracleDatabase
Extension of the Database interface for Oracle specific implementations.
Field Summary | |
---|---|
static int |
DOMAIN_ALL |
static int |
DOMAIN_ARGUMENT |
static int |
DOMAIN_COLUMN |
static int |
DOMAIN_VARIABLE |
static int |
LAST_ORACLE_TYPE The latest oracle type supported by the api. |
static java.lang.String |
NESTED_TABLE_PROPERTY Property name for nested tables. |
static java.lang.String |
OBJECT_TABLE_PROPERTY Property name for Object Tables. |
static int |
OLITE_10GR3_TYPE |
static int |
OLITE_TYPE The type for Oracle Lite databases. |
static java.lang.String |
ORA_BFILE |
static java.lang.String |
ORA_BINARY_DOUBLE |
static java.lang.String |
ORA_BINARY_FLOAT |
static java.lang.String |
ORA_BLOB |
static java.lang.String |
ORA_CHAR |
static java.lang.String |
ORA_CHAR_VARYING |
static java.lang.String |
ORA_CHARACTER |
static java.lang.String |
ORA_CHARACTER_VARYING |
static java.lang.String |
ORA_CLOB |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_TIME_ZONE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_UNIT |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_BYTE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_CHAR |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_LOCAL_TIME_ZONE |
static java.lang.String |
ORA_DATATYPE_ATTRIBUTE_VALUE_TIME_ZONE |
static java.lang.String |
ORA_DATE |
static java.lang.String |
ORA_DEC |
static java.lang.String |
ORA_DECIMAL |
static java.lang.String |
ORA_DOUBLE_PRECISION |
static java.lang.String |
ORA_FLOAT |
static java.lang.String |
ORA_INT |
static java.lang.String |
ORA_INTEGER |
static java.lang.String |
ORA_INTERVAL_DAY |
static java.lang.String |
ORA_INTERVAL_YEAR |
static java.lang.String |
ORA_LONG |
static java.lang.String |
ORA_LONG_RAW |
static java.lang.String |
ORA_LONG_VARCHAR |
static java.lang.String |
ORA_NATIONAL_CHAR |
static java.lang.String |
ORA_NATIONAL_CHAR_VARYING |
static java.lang.String |
ORA_NATIONAL_CHARACTER |
static java.lang.String |
ORA_NATIONAL_CHARACTER_VARYING |
static java.lang.String |
ORA_NCHAR |
static java.lang.String |
ORA_NCHAR_VARYING |
static java.lang.String |
ORA_NCLOB |
static java.lang.String |
ORA_NUMBER |
static java.lang.String |
ORA_NUMERIC |
static java.lang.String |
ORA_NVARCHAR2 |
static java.lang.String |
ORA_RAW |
static java.lang.String |
ORA_REAL |
static java.lang.String |
ORA_ROWID |
static java.lang.String |
ORA_SMALLINT |
static java.lang.String |
ORA_TIMESTAMP |
static java.lang.String |
ORA_UROWID |
static java.lang.String |
ORA_VARCHAR |
static java.lang.String |
ORA_VARCHAR2 |
static java.lang.String |
ORACLE_DATABASE_TYPE The type string for Oracle databases. |
static java.lang.String |
ORACLE_LITE_DATABASE_TYPE The type string for OracleLite databases. |
static int |
ORACLE_TYPE |
static int |
ORACLE10g_TYPE The type for Oracle 10g R1. |
static int |
ORACLE10gR2_TYPE The type for Oracle 10g R2. |
static int |
ORACLE10gR2XE_TYPE The type for Oracle 10g R2 eXpress Edition. |
static int |
ORACLE11g_TYPE The type for Oracle 11g R1. |
static int |
ORACLE11gR2_TYPE The type for Oracle 11g R2. |
static int |
ORACLE8_TYPE |
static int |
ORACLE8i_TYPE |
static int |
ORACLE9i_TYPE |
static int |
ORACLE9iR2_TYPE |
static java.lang.String |
PARTITIONED_TABLE_PROPERTY Property name for Partitioned Tables. |
static java.lang.String |
PASSWORD |
static java.lang.String |
TABLE_COMPRESS_KEY Boolean property indicating if the table is compressed. |
static java.lang.String |
TABLE_PARALLEL_KEY Integer property indicating the degree of parallelism on the table 0 = PARALLEL DEFAULT (Server selects the degree) 1 = NOPARALLEL (default) n = PARALLEL n If the property is not set, this will be interpretted as 1, ie NOPARALLEL. |
static int |
UNKNOWN_TYPE |
static java.lang.String |
USER_PRIVS Property name for user privileges. |
static java.lang.String |
USER_ROLES Property name for user roles. |
Fields inherited from interface oracle.javatools.db.Database |
---|
FOUR_GIG, GENERIC_JDBC_DATABASE, SOURCE_TYPE_BODY, SOURCE_TYPE_SPEC, TWO_GIG |
Fields inherited from interface oracle.javatools.db.DBObjectProvider |
---|
CREATE_PRIVILEDGE, DELETE_PRIVILEDGE, MODIFY_PRIVILEDGE, NEW_FROM_TEMPLATE_TYPE |
Method Summary | |
---|---|
void |
alterSessionParameterValue(java.lang.String parameter, java.lang.String value) Changes the value of given session parameter using ALTER SESION SET parameter = value . |
java.util.List<oracle.javatools.db.compilation.CompilationResults> |
getCompilationResults(java.util.List<PlSqlIdentifier> plsqlIds) Returns a List of CompilationResults for PL/SQL objects defined by the List of PlSqlIdentifier s. |
int |
getDatabaseVersion() Returns the type of Oracle database for this provider. |
int |
getOracleDatabaseType() Deprecated. use getDatabaseVersion() |
java.util.Map<java.lang.String,java.lang.String> |
getSessionParameterQueries() Gets the Map of queries used to build the Session Parameters cache. |
java.lang.String |
getSessionParameterValue(java.lang.String parameter) Returns the value of given parameter from the Session Parameters cache. |
java.lang.String[] |
listTablespaces() Deprecated. listObjects now supports Tablespaces and Schemas |
void |
markSessionParametersDirty() Allows the Session Paramters cache to be marked as dirty so that the next time a value is requested, the cache will be requeried from the database. |
oracle.javatools.db.compilation.CompilationResults |
submitDatabaseSource(java.lang.String schemaName, java.lang.String source) Convenience method for submitting a single source. |
java.util.List<oracle.javatools.db.compilation.CompilationResults> |
submitDatabaseSources(java.lang.String schemaName, java.util.List<java.lang.String> sources) Submits a List of plsql sources to the database to be compiled in the current schema (or the given schemaName if not null). |
boolean |
supportsJava() Returns true if this Oracle version supports java in the database. |
boolean |
supportsPartitioning() Returns true if this Oracle instance supports partitioning of tables. |
Methods inherited from interface oracle.javatools.db.Database |
---|
canRestrictSchemaList, close, exists, getConnection, getConnection, getConnectionName, getConnectionStore, getDatabaseSource, getDatabaseSource, getDatabaseType, getIdentifierQuoteString, getQualifiedName, getUserName, hasTransaction, isConnectionAlive, isConnectionAlive, isConnectionClosed, isObjectValid, supportsDebugging, testSQLStatement |
Field Detail |
---|
static final java.lang.String ORACLE_DATABASE_TYPE
Database.getDatabaseType()
, Constant Field Valuesstatic final java.lang.String ORACLE_LITE_DATABASE_TYPE
Database.getDatabaseType()
, Constant Field Valuesstatic final java.lang.String OBJECT_TABLE_PROPERTY
getProperty
on a Table
with this String for the property name will return Boolean.TRUE
if and only if the Table is an Object Table.
oracle.javatools.db.Table.getProperty
, Constant Field Valuesstatic final java.lang.String NESTED_TABLE_PROPERTY
getProperty
on a table
with this String for the property name will return Boolean.TRUE
if and only if the table is a nested table.
oracle.javatools.db.Table.getProperty
, Constant Field Valuesstatic final java.lang.String PARTITIONED_TABLE_PROPERTY
getProperty
on a Table
with this String for the property name will return Boolean.TRUE
if and only if the Table is a Partitioned Table.
oracle.javatools.db.Table.getProperty
, Constant Field Valuesstatic final java.lang.String TABLE_COMPRESS_KEY
static final java.lang.String TABLE_PARALLEL_KEY
static final java.lang.String USER_PRIVS
getProperty
on a Schema
with this String for the property name will return a Set
containing the privileges granted to that Schema.
static final java.lang.String USER_ROLES
getProperty
on a Schema
with this String for the property name will return a Set
containing the privileges granted to that Schema.
static final java.lang.String PASSWORD
static final int UNKNOWN_TYPE
static final int OLITE_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int OLITE_10GR3_TYPE
static final int ORACLE_TYPE
static final int ORACLE8_TYPE
static final int ORACLE8i_TYPE
static final int ORACLE9i_TYPE
static final int ORACLE9iR2_TYPE
static final int ORACLE10g_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int ORACLE10gR2XE_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int ORACLE10gR2_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int ORACLE11g_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int ORACLE11gR2_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int LAST_ORACLE_TYPE
getDatabaseVersion()
, Constant Field Valuesstatic final int DOMAIN_ALL
static final int DOMAIN_COLUMN
static final int DOMAIN_VARIABLE
static final int DOMAIN_ARGUMENT
static final java.lang.String ORA_BLOB
static final java.lang.String ORA_BFILE
static final java.lang.String ORA_BINARY_DOUBLE
static final java.lang.String ORA_BINARY_FLOAT
static final java.lang.String ORA_CHAR
static final java.lang.String ORA_CHAR_VARYING
static final java.lang.String ORA_CHARACTER
static final java.lang.String ORA_CHARACTER_VARYING
static final java.lang.String ORA_CLOB
static final java.lang.String ORA_DATE
static final java.lang.String ORA_DEC
static final java.lang.String ORA_DECIMAL
static final java.lang.String ORA_DOUBLE_PRECISION
static final java.lang.String ORA_FLOAT
static final java.lang.String ORA_INT
static final java.lang.String ORA_INTEGER
static final java.lang.String ORA_INTERVAL_DAY
static final java.lang.String ORA_INTERVAL_YEAR
static final java.lang.String ORA_LONG
static final java.lang.String ORA_LONG_RAW
static final java.lang.String ORA_LONG_VARCHAR
static final java.lang.String ORA_NATIONAL_CHAR
static final java.lang.String ORA_NATIONAL_CHAR_VARYING
static final java.lang.String ORA_NATIONAL_CHARACTER
static final java.lang.String ORA_NATIONAL_CHARACTER_VARYING
static final java.lang.String ORA_NCHAR
static final java.lang.String ORA_NCHAR_VARYING
static final java.lang.String ORA_NCLOB
static final java.lang.String ORA_NUMBER
static final java.lang.String ORA_NUMERIC
static final java.lang.String ORA_NVARCHAR2
static final java.lang.String ORA_RAW
static final java.lang.String ORA_REAL
static final java.lang.String ORA_ROWID
static final java.lang.String ORA_SMALLINT
static final java.lang.String ORA_TIMESTAMP
static final java.lang.String ORA_UROWID
static final java.lang.String ORA_VARCHAR
static final java.lang.String ORA_VARCHAR2
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_LOCAL_TIME_ZONE
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_UNIT
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_CHAR
static final java.lang.String ORA_DATATYPE_ATTRIBUTE_VALUE_BYTE
Method Detail |
---|
@Deprecated
int getOracleDatabaseType()
getDatabaseVersion()
int getDatabaseVersion()
getDatabaseVersion
in interface Database
ORACLE11g_TYPE
, ORACLE10gR2_TYPE
, ORACLE10g_TYPE
, OLITE_TYPE
, OLITE_10GR3_TYPE
@Deprecated
java.lang.String[] listTablespaces()
boolean supportsJava()
boolean supportsPartitioning()
java.lang.String getSessionParameterValue(java.lang.String parameter)
getSessionParameterQueries()
.void alterSessionParameterValue(java.lang.String parameter, java.lang.String value) throws DBException
ALTER SESION SET parameter = value
.parameter
-value
-DBException
- if the set failsvoid markSessionParametersDirty()
alterSessionParameterValue(java.lang.String, java.lang.String)
as its value cannot be changed with ALTER SESSION for example.java.util.Map<java.lang.String,java.lang.String> getSessionParameterQueries()
markSessionParametersDirty()
).java.util.List<oracle.javatools.db.compilation.CompilationResults> submitDatabaseSources(java.lang.String schemaName, java.util.List<java.lang.String> sources)
CompilationResults
.oracle.javatools.db.compilation.CompilationResults submitDatabaseSource(java.lang.String schemaName, java.lang.String source)
submitDatabaseSources(java.lang.String, java.util.List<java.lang.String>)
for details.java.util.List<oracle.javatools.db.compilation.CompilationResults> getCompilationResults(java.util.List<PlSqlIdentifier> plsqlIds)
CompilationResults
for PL/SQL objects defined by the List of PlSqlIdentifier
s.
|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.9.0) E52944-01 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |