|
|||||||||
PREV NEXT | FRAMES NO FRAMES |
BOOLEAN
.
Statement
object that will generate
ResultSet
objects with the given type and concurrency.
Statement
object that will generate
ResultSet
objects with the given type, concurrency,
and holdability.
DATALINK
.
DATE
class provides conversions between the Oracle Date
(ldx_t) data type and Java classes java.sql.Date
,
java.sql.Time
, java.sql.Timestamp
The internal data for this object is stored as a seven byte array in the
super class' storage area.Statement
object
should be made available for retrieval.
oracle.sql.ARRAY
object.
ARRAY
parameter as an
Array
object in the Java programming language.
java.io.InputStream
object.
Array
object.
oracle.sql.BFILE
object.
NUMERIC
parameter as a
java.math.BigDecimal
object with as many digits to the
right of the decimal point as the value contains.
java.io.InputStream
object.
oracle.sql.BLOB
object.
BLOB
parameter as a
Blob
object in the Java programming language.
BIT
parameter as a
boolean
in the Java programming language.
TINYINT
parameter as a byte
in the Java programming language.
BINARY
or VARBINARY
parameter as an array of byte
values in the Java
programming language.
oracle.sql.CHAR
object.
java.io.Reader
object.
oracle.sql.CLOB
object.
CLOB
parameter as a
Clob
object in the Java programming language.
ResultSet.getObject
is called to retrieve a value
from the column.
Connection
object
that produced this Statement
object.
getJavaSqlConnection()
or
getInternalConnection()
, or
Use getOracleConnection()
instead.
createStatementAsRefCursor
flag which you can set with the
setCreateStatementAsRefCursor
method.
java.sql.ResultSet
object.
oracle.sql.DATE
object.
DATE
parameter as a
java.sql.Date
object.
DATE
parameter as a
java.sql.Date
object, using
the given Calendar
object
to construct the date.
DOUBLE
parameter as a double
in the Java programming language.
Statement
object.
Statement
object.
FLOAT
parameter as a float
in the Java programming language.
Statement
object.
ResultSet
objects
created using this Connection
object.
DatabaseMetaData.getColumns
.
INTEGER
parameter as an int
in the Java programming language.
oracle.sql.INTERVALYM
object.
BIGINT
parameter as a long
in the Java programming language.
Statement
object's next result, deals with
any current ResultSet
object(s) according to the instructions
specified by the given flag, and returns
true
if the next result is a ResultSet
object.
oracle.sql.NUMBER
object.
Ref
object.
Object
in the Java
programming language.
oracle.sql.OPAQUE
object.
oracle.sql.Datum
object.
PreparedStatement.setObject
.
PreparedStatement.setObject
.
PreparedStatement
object for which this OracleParameterMetaData
object
contains information.
PreparedStatement
object for which this ParameterMetaData
object contains
information.
oracle.sql.RAW
object.
oracle.sql.REF
object.
REF(<structured-type>)
parameter as a Ref
object in the Java programming language.
getTables
or
getColumns
of the DatabaseMetaData
interface will
report the REMARKS
column.
DatabaseMetaData.getTables
.
Array
object.
index
and contains up to
count
successive elements.
index
and contains up to
count
successive elements.
Array
object and uses the given
map
to map the array elements.
ResultSet
object.
ResultSet
objects
generated by this Statement
object.
oracle.sql.ROWID
object.
OracleSavepoint
object represents.
Savepoint
object represents.
OracleSavepoint
object represents.
Savepoint
object represents.
SMALLINT
parameter as a short
in the Java programming language.
SQLException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL99.
Struct
object represents.
Struct
object represents.
CHAR
, VARCHAR
,
or LONGVARCHAR
parameter as a String
in
the Java programming language.
oracle.sql.STRUCT
object.
TIME
parameter as a
java.sql.Time
object.
TIME
parameter as a
java.sql.Time
object, using
the given Calendar
object
to construct the time.
oracle.sql.TIMESTAMP
object.
TIMESTAMP
parameter as a
java.sql.Timestamp
object.
TIMESTAMP
parameter as a
java.sql.Timestamp
object, using
the given Calendar
object to construct
the Timestamp
object.
oracle.sql.TIMESTAMPLTZ
object.
oracle.sql.TIMESTAMPTZ
object.
java.io.InputStream
object.
DATALINK
parameter as a
java.net.URL
object.
ResultSet
object as a java.net.URL
object in the Java programming language.
DATALINK
parameter as a
java.net.URL
object.
ResultSet
object as a java.net.URL
object in the Java programming language.
INTERVALYM
class specifies a value to be used to
measure time differences.OraclePreparedStatement
(which
extends the OracleStatement
interface) and incorporates standard
JDBC callable statement functionality.java.sql.Connection
.java.sql.Driver
interface.PreparedStatement
object's parameters.
oracle.jdbc.PreparedStatement
object's parameters.
java.sql.ParameterMetaData
.java.sql.PreparedStatement
.OracleSavepoint
object from the current
transaction.
oracle.jdbc.OracleSavepoint
object from
the current transaction.
OracleSavepoint
object was set.
oracle.jdbc.OracleSavepoint
object was set.
java.sql.Savepoint
.OracleSavepoint
object that
represents it.
oracle.jdbc.OracleSavepoint
object
that represents it.
OracleSavepoint
object that
represents it.
oracle.jdbc.OracleSavepoint
object
that represents it.
java.sql.Statement
and is the superinterface of the
OraclePreparedStatement
and OracleCallableStatement
interfaces.NULL
values.
NULL
values.
CallableStatement
object that will generate
ResultSet
objects with the given type and concurrency.
CallableStatement
object that will generate
ResultSet
objects with the given type and concurrency.
PreparedStatement
object that has
the capability to retrieve auto-generated keys.
PreparedStatement
object capable
of returning the auto-generated keys designated by the given array.
PreparedStatement
object that will generate
ResultSet
objects with the given type and concurrency.
PreparedStatement
object that will generate
ResultSet
objects with the given type, concurrency,
and holdability.
PreparedStatement
object capable
of returning the auto-generated keys designated by the given array.
parameterName
to the JDBC type
sqlType
.
parameterName
to be of JDBC type
sqlType
.
oracle.sql.ARRAY
.
CLOB
value that this Clob
object represents,
starting at position pos
.
oracle.sql.BFILE
value.
oracle.sql.BFILE
value.
java.math.BigDecimal
value.
BLOB
value that this Blob
object represents.
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.
oracle.sql.CHAR
value.
Reader
object, which is the given number of characters long.
CLOB
value that this Clob
object
represents, at position pos
.
Reader
object, which is the given number of characters long.
oracle.sql.CLOB
value.
true
, any new statements created from this
connection will be created as a REF CURSOR
.
oracle.sql.DATE
value.
Calendar
object.
java.sql.Date
value.
java.sql.Date
value,
using the given Calendar
object.
double
value.
String
and executes a
non-padded comparison with a SQL CHAR.
float
value.
ResultSet
objects
created using this Connection
object to the given
holdability.
int
value.
long
value.
NULL
.
oracle.sql.NUMBER
value.
Ref
object references to the given instance of Object
.
oracle.sql.OPAQUE
value.
oracle.sql.Datum
value.
oracle.sql.ORAData
value.
oracle.sql.RAW
value.
oracle.sql.REF
value.
oracle.sql.REF
value.
getTables
and getColumns
calls of the
DatabaseMetaData
interface.
The DatabaseMetaData
calls getTables
and getColumns
are extremely slow if the REMARKS column has to be reported as this
necessitates an expensive outer join so by default the JDBC driver does not report
the REMARKS columns.
You can turn the reporting of REMARKS on by passing a true
argument
to this method.
DatabaseMetaData.getTables.
DatabaseMetaData.getTables
will return information about
all accessible tables, views, and synonyms.
oracle.sql.RAWID
value.
short
value.
String
to the CLOB
value that this Clob
object designates at the position
pos
.
len
characters of str
, starting
at character offset
, to the CLOB
value
that this Clob
represents.
String
value.
oracle.sql.STRUCT
value.
Calendar
object.
java.sql.Time
value.
java.sql.Time
value,
using the given Calendar
object.
Calendar
object.
java.sql.Timestamp
value.
java.sql.Timestamp
value,
using the given Calendar
object.
oracle.sql.TIMESTAMPLTZ
value.
oracle.sql.TIMESTAMPTZ
value.
java.net.URL
value.
java.net.URL
object.
ResultSet
objects
returned from a CallableStatement
object
simultaneously.
TIMESTAMP
class provides conversions between the
Oracle Date (ldx_t) data type and Java classes java.sql.Date
,
java.sql.Time
, java.sql.Timestamp
The internal data for this object is stored as a eleven byte array in the
super class' storage area.TIMESTAMPLTZ
class provides conversions between the
Oracle Date (ldx_t) data type and Java classes java.sql.Date
,
java.sql.Time
, java.sql.Timestamp
The internal data for this object is stored as a eleven byte array in the
super class' storage area.TIMESTAMPTZ
class provides conversions between the
Oracle Date (ldx_t) data type and Java classes java.sql.Date
,
java.sql.Time
, java.sql.Timestamp
The internal data for this object is stored as a thirteen byte array in the
super class' storage area.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.
|
|||||||||
PREV NEXT | FRAMES NO FRAMES |