|
Oracle JDBC API Reference 11g Release 2 ("11.2.0.3.0") |
||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||
BOOLEAN.
Close DataSource API. This removes the associated Connection Cache and frees resources. This must be the last method to invoke, after the user is finished using a cache enabled DataSource.
connection.commit();.
Datum.
DATALINK.
oracle.sql.ARRAY object.
java.io.InputStream object.
OracleResultSet object.
ResultSet.
Array object.
oracle.sql.BFILE object.
oracle.sql.BFILE object.
java.io.InputStream object.
java.io.InputStream object.
oracle.sql.BLOB object.
oracle.sql.CHAR object.
java.io.Reader object.
oracle.sql.CLOB object.
Attempt to obtain a database connection from the Implicit Connection Cache using Connection Attributes
Attempt to obtain a database connection from the Implicit Connection Cache using user, passwd and Connection Attributes
getJavaSqlConnection()getInternalConnection()getOracleConnection()createStatementAsRefCursor flag which you can set with the
setCreateStatementAsRefCursor method.
java.sql.ResultSet object.
oracle.sql.DATE object.
DatabaseMetaData.getColumns.
oracle.sql.INTERVALDS object.
oracle.sql.INTERVALYM object.
oracle.sql.NUMBER object.
OracleData, which is returned by the factory's
"create" method
Ref object.
Return the ONS configuration string that is used for remote ONS subscription, in the form specified in setONSConfiguration(String). This is used by Fast Connection Failover and Runtime Load Balancing.
oracle.sql.OPAQUE object.
oracle.sql.Datum object.
EVENT_TYPE_QUERYCHANGE) kind of
events, this method returns the description of the changes for
each query which result has changed.
oracle.sql.RAW object.
oracle.sql.REF object.
registerAQNotification
method.
getRegId() instead.
getTables or
getColumns of the DatabaseMetaData interface will
report the REMARKS column.
DatabaseMetaData.getTables.
Array object.
Array object and uses the given
map to map the array elements.
index and contains up to
count successive elements.
index and contains up to
count successive elements.
ResultSet
object.
oracle.sql.ROWID object.
SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99.
Struct object represents.
Struct object represents.
Struct object represents.
oracle.sql.STRUCT object.
EVENT_TYPE_OBJCHANGE) kind of
events, this method returns the description of the changes
for each table that was changed.
oracle.sql.TIMESTAMP object.
oracle.sql.TIMESTAMPLTZ object.
oracle.sql.TIMESTAMPTZ object.
java.io.InputStream object.
java.io.InputStream object.
true if this is a SecureFile (LOBs with the STORE
AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
true if this is a SecureFile (LOBs with the STORE
AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
true if this is a SecureFile (LOBs with the STORE
AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
true if this is a SecureFile (LOBs with the STORE
AS SECUREFILE option, which were introduced in Oracle Database 11g Release 1).
oracle.jdbc.OraclePreparedStatement (which
extends the OracleStatement interface) and incorporates standard
JDBC callable statement functionality.java.sql.Connection.java.sql.Driver
interface.PreparedStatement object's parameters.
java.sql.ParameterMetaData.java.sql.PreparedStatement.OracleSavepoint object from the current
transaction.
OracleSavepoint
object was set.
java.sql.Savepoint.OracleSavepoint object that
represents it.
OracleSavepoint object that
represents it.
java.sql.Statement and is the superinterface of the
OraclePreparedStatement and OracleCallableStatement
interfaces.java.sql.Arrayvalue.
oracle.sql.ARRAYvalue.
oracle.sql.ARRAY.
oracle.sql.ARRAY value.
CLOB value that this Clob object represents,
starting at position pos.
oracle.sql.BFILEvalue.
oracle.sql.BFILEvalue.
oracle.sql.BFILE value.
oracle.sql.BFILE value.
oracle.sql.BFILEvalue.
oracle.sql.BFILEvalue.
java.math.BigDecimal value.
oracle.sql.BINARY_FLOAT
value.
oracle.sql.BINARY_FLOAT value.
oracle.sql.BINARY_FLOAT value.
float value.
BLOB
value that this Blob object represents.
oracle.sql.BLOBvalue.
java.sql.Blobvalue.
oracle.sql.BLOB value.
boolean value.
byte value.
BLOB value that
this Blob object represents, starting at position
pos, and returns the number of bytes written.
byte array to the
BLOB value that this Blob object represents
and returns the number of bytes written.
byte[] value.
oracle.sql.CHARvalue.
oracle.sql.CHAR value.
Reader
object, which is the given number of characters long.
CLOB value that this Clob object
represents, at position pos.
oracle.sql.CLOBvalue.
java.sql.Clobvalue.
oracle.sql.CLOB value.
Setter method to set one or more Implicit Connection Cache properties. If a null value is set, default values will take effect. Below are the list of properties supported. These are the keys (case sensitive) to be used when setting their appropriate values.
Setter method to enable Implicit Connection Caching
true, any new statements created from this
connection will be created as a REF CURSOR.
oracle.sql.CustomDatumvalue.
oracle.sql.DATEvalue.
java.sql.Date value.
java.sql.Date value,
using the given Calendar object.
oracle.sql.DATE value.
double value.
String
See the javadoc for the setFixedChar(int, String) method
in OraclePreparedStatement.
String and executes a
non-padded comparison with a SQL CHAR.
float value.
int value.
oracle.sql.INTERVALDSvalue.
oracle.sql.INTERVALYMvalue.
long value.
NULL.
NULL.
oracle.sql.NUMBERvalue.
oracle.sql.NUMBER value.
oracle.sql.NUMBERvalue.
- setObject(String, Object, int, int) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the value of the designated parameter with the given object.
- setObject(String, Object, int) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the value of the designated parameter with the given object.
- setObject(String, Object) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the value of the designated parameter with the given object.
- setObject(Object) -
Method in class oracle.sql.REF
- JDBC 3.0
Sets the structured type value that this
Ref
object references to the given instance of Object.
- setObjectAtName(String, Object, int, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setObjectAtName(String, Object, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setObjectAtName(String, Object) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Object value.
- setONSConfiguration(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Deprecated. Use Oracle Universal Connection Pool instead.
Set the configuration string used for remote ONS subscription.
The parameter string closely resembles the content of the ONS
configuration file "ons.config", and contains a list of "="
pairs separated by newline character '\n', where can be one of
"nodes", "walletfile", or "walletpassword". The parameter string
should at least specify the ONS configuration attribute "nodes", as
a list of host:port pairs separated by comma ','. SSL would be used
when the "walletfile" attribute is specified as an Oracle wallet file.
An example ONS configuration string:
"nodes=host1:4200,host2:4200\nwalletfile=wfile\nwalletpassword=wpwd"
This is used primarily by Fast Connection Failover and Runtime Load
Balancing.
- setOPAQUE(String, OPAQUE) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.OPAQUEvalue.
- setOPAQUE(int, OPAQUE) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.OPAQUE value.
- setOPAQUEAtName(String, OPAQUE) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.OPAQUEvalue.
- setOracleObject(String, Datum) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.Datumvalue.
- setOracleObject(int, Datum) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.Datum value.
- setOracleObjectAtName(String, Datum) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.Datumvalue.
- setORAData(String, ORAData) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.ORADatavalue.
- setORAData(int, ORAData) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.ORAData value.
- setORADataAtName(String, ORAData) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.ORADatavalue.
- setPassword(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the password with which connections have to be obtained.
- setPayload(byte[]) -
Method in interface oracle.jdbc.aq.AQMessage
- Sets a RAW payload.
- setPayload(byte[], byte[]) -
Method in interface oracle.jdbc.aq.AQMessage
- Sets the payload in its linearized form.
- setPayload(STRUCT) -
Method in interface oracle.jdbc.aq.AQMessage
- Sets an ADT payload.
- setPayload(ANYDATA) -
Method in interface oracle.jdbc.aq.AQMessage
- Sets an ANYDATA payload.
- setPayload(RAW) -
Method in interface oracle.jdbc.aq.AQMessage
- Sets a RAW payload.
- setPlsqlIndexTable(int, Object, int, int, int, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds a PL/SQL index-by table parameter in the IN parameter mode.
- setPlsqlWarnings(String) -
Method in interface oracle.jdbc.OracleConnection
- Enable/Disable PLSQL Compiler Warnings
- setPlsqlWarnings(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setPoolConfig(Properties) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
- (Re-)Set the pool configuration for the Cache.
- setPortNumber(int) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the port number where a server is listening for requests.
- setPrecision(long) -
Method in class oracle.sql.TypeDescriptor
-
- setPriority(int) -
Method in interface oracle.jdbc.aq.AQMessageProperties
- Specifies the priority of the message.
- setProperties(Hashtable) -
Method in class oracle.jdbc.pool.OraclePooledConnection
-
- setProtocol(int) -
Method in interface oracle.jdbc.aq.AQAgent
- Protocol to interpret the address and propagate the message.
- setRAW(String, RAW) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.RAWvalue.
- setRAW(int, RAW) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.RAW value.
- setRAWAtName(String, RAW) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.RAWvalue.
- setReadOnly(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setRecipientList(AQAgent[]) -
Method in interface oracle.jdbc.aq.AQMessageProperties
- This parameter is only valid for queues which allow multiple consumers.
- setRef(String, Ref) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
jdbc.sql.Refvalue.
- setREF(String, REF) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setREF(int, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.REF value.
- setRefAtName(String, Ref) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Ref value.
- setREFAtName(String, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setRefType(String, REF) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setRefType(int, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.REF value.
- setRefTypeAtName(String, REF) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.REFvalue.
- setRelativeMessageId(byte[]) -
Method in class oracle.jdbc.aq.AQEnqueueOptions
- Deprecated.
- setRemarksReporting(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Turns on or off the reporting of the REMARKS columns by the
getTables and getColumns calls of the
DatabaseMetaData interface.
- setRemarksReporting(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setRestrictGetTables(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Turns on or off the restriction of the returned data in
DatabaseMetaData.getTables.
- setRestrictGetTables(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setResultSetCache(OracleResultSetCache) -
Method in interface oracle.jdbc.OracleStatement
- Lets you use your own client-side cache implementation for scrollable
result sets.
- setRetrieveMessageId(boolean) -
Method in class oracle.jdbc.aq.AQDequeueOptions
- Set this to true in order to retrieve the message id during
dequeue.
- setRetrieveMessageId(boolean) -
Method in class oracle.jdbc.aq.AQEnqueueOptions
- Set this to true to retrieve the message id back
from the server when the message has been enqueued.
- setROWID(String, ROWID) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.ROWIDvalue.
- setROWID(int, ROWID) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.ROWID value.
- setROWIDAtName(String, ROWID) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.ROWIDvalue.
- setRowPrefetch(int) -
Method in interface oracle.jdbc.OracleStatement
- Sets the value of row prefetch for all result sets created from this
statement.
- setSavepoint() -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setSavepoint(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setScale(byte) -
Method in class oracle.sql.TypeDescriptor
-
- setSender(AQAgent) -
Method in interface oracle.jdbc.aq.AQMessageProperties
- Identifies the original sender of a message.
- setSequenceDeviation(AQEnqueueOptions.SequenceDeviationOption) -
Method in class oracle.jdbc.aq.AQEnqueueOptions
- Deprecated.
- setServerName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the name of the Server on which database is running.
- setServiceName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the service_name of a database on a server.
- setSessionTimeZone(String) -
Method in interface oracle.jdbc.OracleConnection
- Set the session time zone.
- setSessionTimeZone(String) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setShareBytes(byte[]) -
Method in class oracle.sql.Datum
- Sets datum value using a byte array.
- setShort(String, short) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given Java
short value.
- setShortAtName(String, short) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Short value.
- setStatementCacheSize(int) -
Method in interface oracle.jdbc.OracleConnection
- setStatementCacheSize
Specifies the size of the size of the application cache (which will be
used by both implicit and explicit caching).
- setStatementCacheSize(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStatementCacheSize(int) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- setStatementCacheSize
Specifies the size of the size of the application cache (which will be
used by both implicit and explicit caching).
- setStmtCacheSize(int) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. Use setStatementCacheSize() instead.
- setStmtCacheSize(int, boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. Use setStatementCacheSize() instead.
- setStmtCacheSize(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setStmtCacheSize(int) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
- Set the statement cache size.
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.pool.OracleOCIConnectionPool
- Set the statement cache size.
- setStmtCacheSize(int) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- Deprecated.
- setStmtCacheSize(int, boolean) -
Method in class oracle.jdbc.pool.OraclePooledConnection
- Deprecated.
- setString(String, String) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given Java
String value.
- setString(long, String) -
Method in class oracle.sql.CLOB
- JDBC 3.0
Writes the given Java
String to the CLOB
value that this Clob object designates at the position
pos.
- setString(long, String, int, int) -
Method in class oracle.sql.CLOB
- JDBC 3.0
Writes
len characters of str, starting
at character offset, to the CLOB value
that this Clob represents.
- setStringAtName(String, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClob(String, String) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given Java
String value.
- setStringForClob(int, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setStringForClobAtName(String, String) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java String value.
- setSTRUCT(String, STRUCT) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.STRUCTvalue.
- setSTRUCT(int, STRUCT) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to a
oracle.sql.STRUCT value.
- setSTRUCTAtName(String, STRUCT) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.STRUCTvalue.
- setStructDescriptor(String, StructDescriptor) -
Method in interface oracle.jdbc.OracleCallableStatement
-
- setStructDescriptor(int, StructDescriptor) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the bind type of designated parameter from an oracle.sql.StructDescriptor.
- setStructDescriptorAtName(String, StructDescriptor) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.StructDescriptor value.
- setTime(String, Time) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given
java.sql.Time value.
- setTime(String, Time, Calendar) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object.
- setTimeAtName(String, Time) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Time value.
- setTimeAtName(String, Time, Calendar) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Time value.
- setTimestamp(String, Timestamp) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given
java.sql.Timestamp value.
- setTIMESTAMP(String, TIMESTAMP) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPvalue.
- setTimestamp(String, Timestamp, Calendar) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object.
- setTIMESTAMP(int, TIMESTAMP) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an oracle.sql.TIMESTAMP value.
- setTimestampAtName(String, Timestamp) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Timestamp value.
- setTimestampAtName(String, Timestamp, Calendar) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java Timestamp value.
- setTIMESTAMPAtName(String, TIMESTAMP) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMP value.
- setTIMESTAMPLTZ(String, TIMESTAMPLTZ) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPLTZvalue.
- setTIMESTAMPLTZ(int, TIMESTAMPLTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an
oracle.sql.TIMESTAMPLTZ
value.
- setTIMESTAMPLTZAtName(String, TIMESTAMPLTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPLTZ value.
- setTIMESTAMPTZ(String, TIMESTAMPTZ) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPTZvalue.
- setTIMESTAMPTZ(int, TIMESTAMPTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Binds the designated parameter to an
oracle.sql.TIMESTAMPTZ value.
- setTIMESTAMPTZAtName(String, TIMESTAMPTZ) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to an
oracle.sql.TIMESTAMPTZ value.
- setTNSEntryName(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the TNS entry name.
- setTrace(boolean) -
Static method in class oracle.jdbc.driver.OracleLog
- Set the tracing enable variable.
- setTransactionIsolation(int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setTransactionTimeout(int) -
Method in class oracle.jdbc.xa.OracleXAResource
- Set the current transaction timeout value for this XAResource instance.
- setTransformation(String) -
Method in class oracle.jdbc.aq.AQDequeueOptions
- Specifies a transformation that will be applied after dequeuing the message.
- setTransformation(String) -
Method in class oracle.jdbc.aq.AQEnqueueOptions
- Specifies a transformation that will be applied before enqueuing
the message.
- setTypeMap(Map) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setUnicodeStream(String, InputStream, int) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to a Java UnicodeStream value.
- setUnicodeStreamAtName(String, InputStream, int) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java UnicodeStream value.
- setupFromSystemProperties() -
Static method in class oracle.jdbc.driver.OracleLog
- This method uses System.getProperty() to read properties to control
logging.
- setURL(String, URL) -
Method in interface oracle.jdbc.OracleCallableStatement
- Sets the designated parameter to the given
java.net.URL object.
- setURL(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the URL from which connections have to be obtained.
- setURLAtName(String, URL) -
Method in interface oracle.jdbc.OraclePreparedStatement
- Sets the designated parameter to a Java URL value.
- setUser(String) -
Method in class oracle.jdbc.pool.OracleDataSource
- Set the user name with which connections have to be obtained.
- setUsingXAFlag(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated.
- setUsingXAFlag(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- setValue(Object) -
Method in class oracle.sql.REF
- Oracle extension.
- setVisibility(AQDequeueOptions.VisibilityOption) -
Method in class oracle.jdbc.aq.AQDequeueOptions
- Specifies whether the message is dequeued as part of the current
transaction.
- setVisibility(AQEnqueueOptions.VisibilityOption) -
Method in class oracle.jdbc.aq.AQEnqueueOptions
- Specifies the transactional behavior of the enqueue request.
- setWait(int) -
Method in class oracle.jdbc.aq.AQDequeueOptions
- Specifies the wait time if there is currently no message available which matches the
search criterion.
- setWrapper(OracleConnection) -
Method in interface oracle.jdbc.OracleConnection
- Set the wrapping object.
- setWrapper(OracleConnection) -
Method in class oracle.jdbc.OracleConnectionWrapper
- Set a connection wrapper as the wrapper of this connection.
- setXAErrorFlag(boolean) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated.
- setXAErrorFlag(boolean) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- SEZERO -
Static variable in class oracle.sql.DATE
- Zero valued second
- SF7ASCII_CHARSET -
Static variable in class oracle.sql.CharacterSet
-
- SF7DEC_CHARSET -
Static variable in class oracle.sql.CharacterSet
-
- shareBytes() -
Method in class oracle.sql.Datum
- Retrieve the data bytes.
- shift(int) -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized the NUMBER value shifted digits
decimal places.
- shortValue() -
Method in class oracle.sql.NUMBER
- Calls toShort to convert internal Oracle Number to a Java short.
- shutdown(OracleConnection.DatabaseShutdownMode) -
Method in interface oracle.jdbc.OracleConnection
- Shuts the database server down.
- shutdown(OracleConnection.DatabaseShutdownMode) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- sign() -
Method in class oracle.sql.NUMBER
- Returns -1 if the sign of NUMBER is negative, 0 if NUMBER is 0, and > 0
if NUMBER is positive.
- sin() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the sine of the NUMBER.
- sinh() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the hyperbolic sine of NUMBER.
- SIZE_DATE -
Static variable in class oracle.sql.TIMESTAMP
-
- SIZE_TIMESTAMP -
Static variable in class oracle.sql.TIMESTAMP
-
- SIZE_TIMESTAMP_NOFRAC -
Static variable in class oracle.sql.TIMESTAMP
-
- SMALLINT -
Static variable in class oracle.jdbc.OracleTypes
-
- sql_exception_string -
Static variable in class oracle.jdbc.pool.OraclePooledConnection
-
- sqroot() -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the square root of NUMBER.
- start(Xid, int) -
Method in class oracle.jdbc.xa.client.OracleXAHeteroResource
- Starts work on behalf of a transaction branch.
- start(Xid, int) -
Method in class oracle.jdbc.xa.client.OracleXAResource
- start() -- Starts work on behalf of a transaction branch.
- start(Xid, int) -
Method in class oracle.jdbc.xa.OracleXAResource
- start() -- Starts work on behalf of a transaction branch.
- startup(String, int) -
Method in interface oracle.jdbc.OracleConnection
- Deprecated. This method will be removed in a future version.
- startup(OracleConnection.DatabaseStartupMode) -
Method in interface oracle.jdbc.OracleConnection
- Starts the database server up.
- startup(String, int) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- startup(OracleConnection.DatabaseStartupMode) -
Method in class oracle.jdbc.OracleConnectionWrapper
-
- statement_cache_size -
Static variable in class oracle.jdbc.pool.OraclePooledConnection
-
- storesLowerCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in lower case?
- storesLowerCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in lower case?
- storesMixedCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in mixed case?
- storesMixedCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in mixed case?
- storesUpperCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case insensitive and store them in upper case?
- storesUpperCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case insensitive and store them in upper case?
- string32UTF8Length(String) -
Static method in class oracle.sql.CharacterSet
- Returns the number of bytes in the UTF-8 representation of a String
- stringToAL16UTF16Bytes(String) -
Static method in class oracle.sql.CharacterSet
- Convert a String to an array of bytes this function will allocate the
bytes array
- stringToAL16UTF16LEBytes(String) -
Static method in class oracle.sql.CharacterSet
- Convert a String to an array of bytes this function will allocate the
bytes array
- stringToAL32UTF8(String) -
Static method in class oracle.sql.CharacterSet
-
- stringToASCII(String) -
Static method in class oracle.sql.CharacterSet
- convert a String to a byte array in ascii.
- stringToUTF(String) -
Static method in class oracle.sql.CharacterSet
- Convert the str to a byte array that in UTF8 representation.
- stringUTFLength(String) -
Static method in class oracle.sql.CharacterSet
- Returns the number of bytes in the UTF8 representation of a String
- stringValue() -
Method in class oracle.sql.ANYDATA
- Returns a string representation of this ANYDATA.
- stringValue(Connection) -
Method in class oracle.sql.ANYDATA
- Returns a string representation of this ANYDATA.
- stringValue() -
Method in class oracle.sql.ARRAY
-
- stringValue() -
Method in class oracle.sql.BINARY_DOUBLE
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.BINARY_FLOAT
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.CHAR
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.CLOB
- Convert to a String representation of the datum object
- stringValue() -
Method in class oracle.sql.DATE
- Calls toString to convert internal Oracle Date to a Java String.
- stringValue() -
Method in class oracle.sql.Datum
- Convert to a String representation of the datum object
- stringValue(Connection) -
Method in class oracle.sql.Datum
- Some Datum subclass such as TIMESTAMPTZ will override
this default implementation which simply ignores the
the connection.
- stringValue() -
Method in class oracle.sql.INTERVALDS
- Returns String for this INTERVALDS object
- stringValue() -
Method in class oracle.sql.INTERVALYM
- Returns String for this INTERVALYM object
- stringValue() -
Method in class oracle.sql.NUMBER
- Calls toString to convert internal Oracle Number to a Java String.
- stringValue() -
Method in class oracle.sql.OPAQUE
-
- stringValue() -
Method in class oracle.sql.RAW
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.ROWID
- Convert this data object into a String.
- stringValue() -
Method in class oracle.sql.TIMESTAMP
- Calls toString to convert internal Oracle TIMESTAMP to a Java String.
- stringValue(Connection) -
Method in class oracle.sql.TIMESTAMPLTZ
- Calls toString(Connection, byte[]) to convert internal Oracle
TIMESTAMPLTZ to a Java String.
- stringValue(Connection, Calendar) -
Method in class oracle.sql.TIMESTAMPLTZ
- Calls toString(Connection, byte[], Calendar) to convert internal Oracle
TIMESTAMPLTZ to a Java String.
- stringValue(Connection) -
Method in class oracle.sql.TIMESTAMPTZ
- Calls toString to convert internal Oracle TIMESTAMPTZ to a Java String.
- STRUCT -
Static variable in class oracle.jdbc.OracleTypes
-
- STRUCT - Class in oracle.sql
- This class has two roles.
- STRUCT(StructDescriptor, Connection, Object[]) -
Constructor for class oracle.sql.STRUCT
- Constructor.
- STRUCT(StructDescriptor, Connection, Map) -
Constructor for class oracle.sql.STRUCT
-
- StructDescriptor - Class in oracle.sql
- Descriptor of a SQL structured object.
- StructMetaData - Interface in oracle.jdbc
- An interface to get information about structured column types.
- sub(NUMBER) -
Method in class oracle.sql.NUMBER
- Returns a new NUMBER object initialized to the difference of NUMBER and n.
- supportsAlterTableWithAddColumn() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is "ALTER TABLE" with add column supported?
- supportsAlterTableWithDropColumn() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is "ALTER TABLE" with drop column supported?
- supportsANSI92EntryLevelSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 entry level SQL grammar supported?
All JDBC compliant drivers must return true.
- supportsANSI92FullSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 full SQL grammar supported?
- supportsANSI92IntermediateSQL() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ANSI92 intermediate SQL grammar supported?
- supportsBatchUpdates() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData::supportBatchUpdates.
- supportsCatalogsInDataManipulation() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a data manipulation statement?
- supportsCatalogsInIndexDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a index definition statement?
- supportsCatalogsInPrivilegeDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a privilege definition statement?
- supportsCatalogsInProcedureCalls() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a procedure call statement?
- supportsCatalogsInTableDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a catalog name be used in a table definition statement?
- supportsColumnAliasing() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is column aliasing supported?
- supportsConvert() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the CONVERT function between SQL types supported?
- supportsConvert(int, int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is CONVERT between the given SQL types supported?
- supportsCoreSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Core SQL grammar supported?
- supportsCorrelatedSubqueries() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are correlated subqueries supported?
A JDBC compliant driver always returns true.
- supportsDataDefinitionAndDataManipulationTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are both data definition and data manipulation statements
within a transaction supported?
- supportsDataManipulationTransactionsOnly() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are only data manipulation statements within a transaction
supported?
- supportsDifferentTableCorrelationNames() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- If table correlation names are supported, are they restricted
to be different from the names of the tables?
- supportsExpressionsInOrderBy() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are expressions in "ORDER BY" lists supported?
- supportsExtendedSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Extended SQL grammar supported?
- supportsFullOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are full nested outer joins supported?
- supportsGetGeneratedKeys() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether auto-generated keys can be retrieved after
a statement has been executed.
- supportsGroupBy() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is some form of "GROUP BY" clause supported?
- supportsGroupByBeyondSelect() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a "GROUP BY" clause add columns not in the SELECT
provided it specifies all the columns in the SELECT?
- supportsGroupByUnrelated() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a "GROUP BY" clause use columns not in the SELECT?
- supportsIntegrityEnhancementFacility() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the SQL Integrity Enhancement Facility supported?
- supportsLikeEscapeClause() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the escape character in "LIKE" clauses supported?
A JDBC compliant driver always returns true.
- supportsLimitedOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is there limited support for outer joins? (This will be true
if supportFullOuterJoins is true.)
- supportsMinimumSQLGrammar() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is the ODBC Minimum SQL grammar supported?
All JDBC compliant drivers must return true.
- supportsMixedCaseIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case unquoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC compliant driver will always return false.
- supportsMixedCaseQuotedIdentifiers() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database treat mixed case quoted SQL identifiers as
case sensitive and as a result store them in mixed case?
A JDBC compliant driver will always return false.
- supportsMultipleOpenResults() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether it is possible to have multiple
ResultSet objects
returned from a CallableStatement object
simultaneously.
- supportsMultipleResultSets() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are multiple ResultSets from a single execute supported?
- supportsMultipleTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can we have multiple transactions open at once (on different
connections)?
- supportsNamedParameters() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports named parameters to callable
statements.
- supportsNonNullableColumns() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can columns be defined as non-nullable?
A JDBC compliant driver always returns true.
- supportsOpenCursorsAcrossCommit() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can cursors remain open across commits?
- supportsOpenCursorsAcrossRollback() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can cursors remain open across rollbacks?
- supportsOpenStatementsAcrossCommit() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can statements remain open across commits?
- supportsOpenStatementsAcrossRollback() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can statements remain open across rollbacks?
- supportsOrderByUnrelated() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can an "ORDER BY" clause use columns not in the SELECT?
- supportsOuterJoins() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is some form of outer join supported?
- supportsPositionedDelete() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is positioned DELETE supported?
NOTE: Though Oracle supports positional delete through the use of ROWID
positional delete as specified by SQLJ92 standard is not supported
which is being followed by JDBC 2.1 API Spec.
- supportsPositionedUpdate() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is positioned UPDATE supported?
NOTE: Though Oracle supports positional updates through the use of ROWID
positional updates as specified by SQLJ92 standard is not supported
which is being followed by JDBC 2.1 API Spec.
- supportsResultSetConcurrency(int, int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData.supportsResultSetConcurrency.
- supportsResultSetHoldability(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports the given result set holdability.
- supportsResultSetType(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Implements JDBC 2.0 DatabaseMetaData.supportsResultSetType.
- supportsSavepoints() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
Retrieves whether this database supports savepoints.
- supportsSchemasInDataManipulation() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a data manipulation statement?
- supportsSchemasInIndexDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in an index definition statement?
- supportsSchemasInPrivilegeDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a privilege definition statement?
- supportsSchemasInProcedureCalls() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a procedure call statement?
- supportsSchemasInTableDefinitions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Can a schema name be used in a table definition statement?
- supportsSelectForUpdate() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SELECT for UPDATE supported?
- supportsStatementPooling() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- JDBC 3.0
- supportsStoredProcedures() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are stored procedure calls using the stored procedure escape
syntax supported?
- supportsSubqueriesInComparisons() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in comparison expressions supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInExists() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in exists expressions supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInIns() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in "in" statements supported?
A JDBC compliant driver always returns true.
- supportsSubqueriesInQuantifieds() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are subqueries in quantified expressions supported?
A JDBC compliant driver always returns true.
- supportsTableCorrelationNames() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are table correlation names supported?
A JDBC compliant driver always returns true.
- supportsTransactionIsolationLevel(int) -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Does the database support the given transaction isolation level?
- supportsTransactions() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Are transactions supported? If not, commit is a noop and the
isolation level is TRANSACTION_NONE.
- supportsUnion() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SQL UNION supported?
- supportsUnionAll() -
Method in class oracle.jdbc.OracleDatabaseMetaData
- Is SQL UNION ALL supported?
BLOB value that this Blob
object represents to be len bytes in length.
CLOB value that this Clob
designates to have a length of len
characters.
|
Oracle JDBC API Reference 11g Release 2 ("11.2.0.3.0") |
||||||||
| PREV NEXT | FRAMES NO FRAMES | ||||||||