|
Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference 11g Release 1 (11.1.1.7.0) E13403-08 |
|||||||||
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, 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)
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.7.0) E13403-08 |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |