Skip navigation links

oracle.jdbc
Interface OracleResultSet

All Superinterfaces:

ResultSet, Wrapper

public interface OracleResultSet

extends ResultSet

A table of data representing a database result set, which is usually generated by executing a statement that queries the database.

Nested Class Summary

static class

OracleResultSet.AuthorizationIndicator eXtensible Data Security (XDS) authorization indicator.

Field Summary

Fields inherited from interface java.sql.ResultSet

CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE

Method Summary

ARRAY	getARRAY(int columnIndex) Oracle extension.
ARRAY	getARRAY(String columnName) Oracle extension.
OracleResultSet.AuthorizationIndicator	getAuthorizationIndicator(int columnIndex) Retrieves the column security visibility attribute of the designated column in the current row of this OracleResultSet object.
OracleResultSet.AuthorizationIndicator	getAuthorizationIndicator(String columnName) Retrieves the column security visibility attribute of the designated column in the current row of this OracleResultSet.
BFILE	getBfile(int columnIndex) Oracle extension.
BFILE	getBFILE(int columnIndex) Oracle extension.
BFILE	getBfile(String columnName) Oracle extension.
BFILE	getBFILE(String columnName) Oracle extension.
BLOB	getBLOB(int columnIndex) Oracle extension.
BLOB	getBLOB(String columnName) Oracle extension.
CHAR	getCHAR(int columnIndex) Oracle extension.
CHAR	getCHAR(String columnName) Oracle extension.
CLOB	getCLOB(int columnIndex) Oracle extension.
CLOB	getCLOB(String columnName) Oracle extension.
ResultSet	getCursor(int columnIndex) Oracle extension.
ResultSet	getCursor(String columnName) Oracle extension.
CustomDatum	getCustomDatum(int columnIndex, CustomDatumFactory factory) Deprecated.
CustomDatum	getCustomDatum(String columnName, CustomDatumFactory factory) Deprecated.
DATE	getDATE(int columnIndex) Oracle extension.
DATE	getDATE(String columnName) Oracle extension.
INTERVALDS	getINTERVALDS(int columnIndex) Obtain an oracle.sql.INTERVALDS value from the ResultSet.
INTERVALDS	getINTERVALDS(String columnName) Obtain an oracle.sql.INTERVALDS value from the ResultSet.
INTERVALYM	getINTERVALYM(int columnIndex) Obtain an oracle.sql.INTERVALYM value from the ResultSet.
INTERVALYM	getINTERVALYM(String columnName) Obtain an oracle.sql.INTERVALYM value from the ResultSet.
NUMBER	getNUMBER(int columnIndex) Oracle extension.
NUMBER	getNUMBER(String columnName) Oracle extension.
Object	getObject(int columnIndex, OracleDataFactory oracleDataFactory) Oracle extension Get the column value as an instance of a subclass of OracleData.
Object	getObject(String columnName, OracleDataFactory oracleDataFactory) Oracle extension Get the column value as an instance of a subclass of OracleData.
OPAQUE	getOPAQUE(int columnIndex) Oracle extension.
OPAQUE	getOPAQUE(String columnName) Oracle extension.
Datum	getOracleObject(int columnIndex) Oracle extension.
Datum	getOracleObject(String columnName) Oracle extension.
ORAData	getORAData(int columnIndex, ORADataFactory factory) Oracle extension.
ORAData	getORAData(String columnName, ORADataFactory factory) Oracle extension.
RAW	getRAW(int columnIndex) Oracle extension.
RAW	getRAW(String columnName) Oracle extension.
REF	getREF(int columnIndex) Oracle extension.
REF	getREF(String columnName) Oracle extension.
ROWID	getROWID(int columnIndex) Oracle extension.
ROWID	getROWID(String columnName) Oracle extension.
STRUCT	getSTRUCT(int columnIndex) Oracle extension.
STRUCT	getSTRUCT(String columnName) Oracle extension.
TIMESTAMP	getTIMESTAMP(int columnIndex) Obtain an oracle.sql.TIMESTAMP value from the ResultSet.
TIMESTAMP	getTIMESTAMP(String columnName) Obtain an oracle.sql.TIMESTAMP value from the ResultSet.
TIMESTAMPLTZ	getTIMESTAMPLTZ(int columnIndex) Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.
TIMESTAMPLTZ	getTIMESTAMPLTZ(String columnName) Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.
TIMESTAMPTZ	getTIMESTAMPTZ(int columnIndex) Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.
TIMESTAMPTZ	getTIMESTAMPTZ(String columnName) Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.
void	updateARRAY(int columnIndex, ARRAY value) Oracle extension.
void	updateARRAY(String columnName, ARRAY value) Oracle extension.
void	updateBfile(int columnIndex, BFILE value) Oracle extension.
void	updateBFILE(int columnIndex, BFILE value) Oracle extension.
void	updateBfile(String columnName, BFILE value) Oracle extension.
void	updateBFILE(String columnName, BFILE value) Oracle extension.
void	updateBLOB(int columnIndex, BLOB value) Oracle extension.
void	updateBLOB(String columnName, BLOB value) Oracle extension.
void	updateCHAR(int columnIndex, CHAR value) Oracle extension.
void	updateCHAR(String columnName, CHAR value) Oracle extension.
void	updateCLOB(int columnIndex, CLOB value) Oracle extension.
void	updateCLOB(String columnName, CLOB value) Oracle extension.
void	updateCustomDatum(int columnIndex, CustomDatum value) Deprecated.
void	updateCustomDatum(String columnName, CustomDatum value) Deprecated.
void	updateDATE(int columnIndex, DATE value) Oracle extension.
void	updateDATE(String columnName, DATE value) Oracle extension.
void	updateINTERVALDS(int columnIndex, INTERVALDS value) Oracle extension.
void	updateINTERVALDS(String columnName, INTERVALDS value) Oracle extension.
void	updateINTERVALYM(int columnIndex, INTERVALYM value) Oracle extension.
void	updateINTERVALYM(String columnName, INTERVALYM value) Oracle extension.
void	updateNUMBER(int columnIndex, NUMBER value) Oracle extension.
void	updateNUMBER(String columnName, NUMBER value) Oracle extension.
void	updateOracleObject(int columnIndex, Datum value) Oracle extension.
void	updateOracleObject(String columnName, Datum value) Oracle extension.
void	updateORAData(int columnIndex, ORAData value) Oracle extension.
void	updateORAData(String columnName, ORAData value) Oracle extension.
void	updateRAW(int columnIndex, RAW value) Oracle extension.
void	updateRAW(String columnName, RAW value) Oracle extension.
void	updateREF(int columnIndex, REF value) Oracle extension.
void	updateREF(String columnName, REF value) Oracle extension.
void	updateROWID(int columnIndex, ROWID value) Oracle extension.
void	updateROWID(String columnName, ROWID value) Oracle extension.
void	updateSTRUCT(int columnIndex, STRUCT value) Oracle extension.
void	updateSTRUCT(String columnName, STRUCT value) Oracle extension.
void	updateTIMESTAMP(int columnIndex, TIMESTAMP value) Oracle extension.
void	updateTIMESTAMP(String columnName, TIMESTAMP value) Oracle extension.
void	updateTIMESTAMPLTZ(int columnIndex, TIMESTAMPLTZ value) Oracle extension.
void	updateTIMESTAMPLTZ(String columnName, TIMESTAMPLTZ value) Oracle extension.
void	updateTIMESTAMPTZ(int columnIndex, TIMESTAMPTZ value) Oracle extension.
void	updateTIMESTAMPTZ(String columnName, TIMESTAMPTZ value) Oracle extension.

Methods inherited from interface java.sql.ResultSet

absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, close, deleteRow, findColumn, first, getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getDate, getDate, getDate, getDate, getDouble, getDouble, getFetchDirection, getFetchSize, getFloat, getFloat, getHoldability, getInt, getInt, getLong, getLong, getMetaData, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getRef, getRef, getRow, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getStatement, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getType, getUnicodeStream, getUnicodeStream, getURL, getURL, getWarnings, insertRow, isAfterLast, isBeforeFirst, isClosed, isFirst, isLast, last, moveToCurrentRow, moveToInsertRow, next, previous, refreshRow, relative, rowDeleted, rowInserted, rowUpdated, setFetchDirection, setFetchSize, updateArray, updateArray, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBigDecimal, updateBigDecimal, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBoolean, updateBoolean, updateByte, updateByte, updateBytes, updateBytes, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateDate, updateDate, updateDouble, updateDouble, updateFloat, updateFloat, updateInt, updateInt, updateLong, updateLong, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNString, updateNString, updateNull, updateNull, updateObject, updateObject, updateObject, updateObject, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull

Methods inherited from interface java.sql.Wrapper

isWrapperFor, unwrap

Method Detail

getARRAY

ARRAY getARRAY(int columnIndex)
               throws SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.ARRAY

Throws:

SQLException - if a database access error occurs.

getARRAY

ARRAY getARRAY(String columnName)
               throws SQLException

Oracle extension. Get the column value as a ARRAY. An ARRAY instance maps to a Nested Table or VARRAY value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.ARRAY

Throws:

SQLException - if a database access error occurs.

getBfile

BFILE getBfile(int columnIndex)
               throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws:

SQLException - if a database access error occurs.

getBFILE

BFILE getBFILE(int columnIndex)
               throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BFILE

Throws:

SQLException - if a database access error occurs.

getBfile

BFILE getBfile(String columnName)
               throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws:

SQLException - if a database access error occurs.

getBFILE

BFILE getBFILE(String columnName)
               throws SQLException

Oracle extension. Get the column as a BFILE locator. BFILES are large binary data objects stored in operating system files outside of database tablespaces. These files use reference semantics. They may also be located on tertiary storage devices such as hard disks, CD-ROMs, PhotoCDs and DVDs. Like BLOBs and CLOBs, a BFILE is accessed and referenced by a locator which is stored in the database table and points to the BFILE data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BFILE

Throws:

SQLException - if a database access error occurs.

getBLOB

BLOB getBLOB(int columnIndex)
             throws SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.BLOB

Throws:

SQLException - if a database access error occurs.

getBLOB

BLOB getBLOB(String columnName)
             throws SQLException

Oracle extension. Get the column value as a BLOB (unstructured binary data). BLOB data is accessed and referenced by using a locator which is stored in the database table and points to the BLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.BLOB

Throws:

SQLException - if a database access error occurs.

getCHAR

CHAR getCHAR(int columnIndex)
             throws SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CHAR

Throws:

SQLException - if a database access error occurs.

getCHAR

CHAR getCHAR(String columnName)
             throws SQLException

Oracle extension. Get the column as a CHAR value. CHAR values retain the same same representation as they have in the database, so there can be no loss of information through conversion. While the vast majority of characters in the various Oracle NLS character sets are represented in the Unicode character set used by Java there are a very small number that are not. Additionally, JDBC does not have to perform any conversion when getting character data as CHAR, so getCHAR is slightly efficient than getString.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CHAR

Throws:

SQLException - if a database access error occurs.

getCLOB

CLOB getCLOB(int columnIndex)
             throws SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.CLOB

Throws:

SQLException - if a database access error occurs.

getCLOB

CLOB getCLOB(String columnName)
             throws SQLException

Oracle extension. Get the column value as a CLOB (single-byte character data). CLOB data is accessed and referenced by using a locator which is stored in the database table and points to the CLOB data.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.CLOB

Throws:

SQLException - if a database access error occurs.

getOPAQUE

OPAQUE getOPAQUE(int columnIndex)
                 throws SQLException

Oracle extension. Get the column value as an OPAQUE.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.OPAQUE

Throws:

SQLException - if a database access error occurs.

getOPAQUE

OPAQUE getOPAQUE(String columnName)
                 throws SQLException

Oracle extension. Get the column value as an OPAQUE.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.OPAQUE

Throws:

SQLException - if a database access error occurs.

getINTERVALYM

INTERVALYM getINTERVALYM(int columnIndex)
                         throws SQLException

Obtain an oracle.sql.INTERVALYM value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getINTERVALYM

INTERVALYM getINTERVALYM(String columnName)
                         throws SQLException

Obtain an oracle.sql.INTERVALYM value from the ResultSet.

Parameters:

columnName - column name.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getINTERVALDS

INTERVALDS getINTERVALDS(int columnIndex)
                         throws SQLException

Obtain an oracle.sql.INTERVALDS value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

10i

getINTERVALDS

INTERVALDS getINTERVALDS(String columnName)
                         throws SQLException

Obtain an oracle.sql.INTERVALDS value from the ResultSet.

Parameters:

columnName - column name.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

10i

getTIMESTAMP

TIMESTAMP getTIMESTAMP(int columnIndex)
                       throws SQLException

Obtain an oracle.sql.TIMESTAMP value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getTIMESTAMP

TIMESTAMP getTIMESTAMP(String columnName)
                       throws SQLException

Obtain an oracle.sql.TIMESTAMP value from the ResultSet.

Parameters:

columnName - column name.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getTIMESTAMPTZ

TIMESTAMPTZ getTIMESTAMPTZ(int columnIndex)
                           throws SQLException

Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getTIMESTAMPTZ

TIMESTAMPTZ getTIMESTAMPTZ(String columnName)
                           throws SQLException

Obtain an oracle.sql.TIMESTAMPTZ value from the ResultSet.

Parameters:

columnName - column name.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getTIMESTAMPLTZ

TIMESTAMPLTZ getTIMESTAMPLTZ(int columnIndex)
                             throws SQLException

Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.

Parameters:

columnIndex - parameter number.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getTIMESTAMPLTZ

TIMESTAMPLTZ getTIMESTAMPLTZ(String columnName)
                             throws SQLException

Obtain an oracle.sql.TIMESTAMPLTZ value from the ResultSet.

Parameters:

columnName - column name.

Returns:

the obtained value.

Throws:

SQLException - if an error occurred.

Since:

9i

getCursor

ResultSet getCursor(int columnIndex)
                    throws SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the REFCURSOR column value as a ResultSet

Throws:

SQLException - if a database access error occurs

getCursor

ResultSet getCursor(String columnName)
                    throws SQLException

Oracle extension. Get the REFCURSOR value of the column as a ResultSet.

Parameters:

columnName - the name of the column

Returns:

the REFCURSOR column value as a ResultSet

Throws:

SQLException - if a database access error occurs

getCustomDatum

CustomDatum getCustomDatum(int columnIndex,
                           CustomDatumFactory factory)
                           throws SQLException

Deprecated.

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getORAData

ORAData getORAData(int columnIndex,
                   ORADataFactory factory)
                   throws SQLException

Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - ORADataFactory used to materialize the column value

Returns:

the column value as a ORAData; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getObject

Object getObject(int columnIndex,
                 OracleDataFactory oracleDataFactory)
                 throws SQLException

Oracle extension Get the column value as an instance of a subclass of OracleData. Which subclass is determined by the factory parameter.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

factory - OracleDataFactory used to materialize the column value

Returns:

the column value as a OracleData; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getObject

Object getObject(String columnName,
                 OracleDataFactory oracleDataFactory)
                 throws SQLException

Oracle extension Get the column value as an instance of a subclass of OracleData. Which subclass is determined by the factory parameter.

Parameters:

columnName - name of the column "column1" "column2" ..

factory - OracleDataFactory used to materialize the column value

Returns:

the column value as a OracleData; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getCustomDatum

CustomDatum getCustomDatum(String columnName,
                           CustomDatumFactory factory)
                           throws SQLException

Deprecated.

Oracle extension. Get the column value as an instance of a subclass of CustomDatum. Which subclass is determined by the factory parameter.

Parameters:

columnName - the name of the column

factory - CustomDatumFactory used to materialize the column value

Returns:

the column value as a CustomDatum; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getORAData

ORAData getORAData(String columnName,
                   ORADataFactory factory)
                   throws SQLException

Oracle extension. Get the column value as an instance of a subclass of ORAData. Which subclass is determined by the factory parameter.

Parameters:

columnName - the name of the column

factory - ORADataFactory used to materialize the column value

Returns:

the column value as a ORAData; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getDATE

DATE getDATE(int columnIndex)
             throws SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.DATE

Throws:

SQLException - if a database access error occurs.

getDATE

DATE getDATE(String columnName)
             throws SQLException

Oracle extension. Get the column value as a DATE.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.DATE

Throws:

SQLException - if a database access error occurs.

getNUMBER

NUMBER getNUMBER(int columnIndex)
                 throws SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.NUMBER

Throws:

SQLException - if a database access error occurs.

getNUMBER

NUMBER getNUMBER(String columnName)
                 throws SQLException

Oracle extension. Get the column value as a NUMBER. NUMBER values have the same representation as Oracle numbers in the database, thus they have exactly the same value. Getting numeric values as other types can result in very slightly different values due to the difference in representation. Additionally, JDBC does not have to do any conversion when using getNUMBER and so is more efficient.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.NUMBER

Throws:

SQLException - if a database access error occurs.

getOracleObject

Datum getOracleObject(int columnIndex)
                      throws SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types, so there is no possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getOracleObject

Datum getOracleObject(String columnName)
                      throws SQLException

Oracle extension. Get the column value as the appropriate oracle.sql. type. This differs from getObject in that getObject returns the appropriate jdbc.sql. type. The Oracle specific types in oracle.sql more closely model the underlying Oracle database types possible loss of information due to conversion and slightly greater efficiency.

Parameters:

columnName - the name of the column

Returns:

the column value as the appropriate oracle.sql. type; if the value is SQL NULL, the result is null

Throws:

SQLException - if a database access error occurs.

getRAW

RAW getRAW(int columnIndex)
           throws SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.RAW

Throws:

SQLException - if a database access error occurs.

getRAW

RAW getRAW(String columnName)
           throws SQLException

Oracle extension. Get the column value as a RAW. A RAW instance maps to a RAW or LONG RAW value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.RAW

Throws:

SQLException - if a database access error occurs.

getREF

REF getREF(int columnIndex)
           throws SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.REF

Throws:

SQLException - if a database access error occurs.

getREF

REF getREF(String columnName)
           throws SQLException

Oracle extension. Get the column value as a REF. A REF instance maps to a REF (to a row or concreated object) value in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.REF

Throws:

SQLException - if a database acc

getROWID

ROWID getROWID(int columnIndex)
               throws SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws:

SQLException - if a database access error occurs.

getROWID

ROWID getROWID(String columnName)
               throws SQLException

Oracle extension. Get the ROWID column value as ROWID.

Parameters:

columnName - the name of the column

Returns:

the ROWID column value as an oracle.sql.ROWID

Throws:

SQLException - if a database access error occurs.

getSTRUCT

STRUCT getSTRUCT(int columnIndex)
                 throws SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

Returns:

the column value as an oracle.sql.STRUCT

Throws:

SQLException - if a database access error occurs.

See Also:

getORAData

getSTRUCT

STRUCT getSTRUCT(String columnName)
                 throws SQLException

Oracle extension. Get the column value as a STRUCT. A STRUCT instance maps to a structured data type instance in database.

Parameters:

columnName - the name of the column

Returns:

the column value as an oracle.sql.STRUCT

Throws:

SQLException - if a database access error occurs.

See Also:

getORAData

updateARRAY

void updateARRAY(int columnIndex,
                 ARRAY value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateARRAY

void updateARRAY(String columnName,
                 ARRAY value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.ARRAY value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBfile

void updateBfile(int columnIndex,
                 BFILE value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBFILE

void updateBFILE(int columnIndex,
                 BFILE value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBfile

void updateBfile(String columnName,
                 BFILE value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBFILE

void updateBFILE(String columnName,
                 BFILE value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.BFILE value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBLOB

void updateBLOB(int columnIndex,
                BLOB value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateBLOB

void updateBLOB(String columnName,
                BLOB value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.BLOB value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCHAR

void updateCHAR(int columnIndex,
                CHAR value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCHAR

void updateCHAR(String columnName,
                CHAR value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.CHAR value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCLOB

void updateCLOB(int columnIndex,
                CLOB value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCLOB

void updateCLOB(String columnName,
                CLOB value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.CLOB value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCustomDatum

void updateCustomDatum(int columnIndex,
                       CustomDatum value)
                       throws SQLException

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateORAData

void updateORAData(int columnIndex,
                   ORAData value)
                   throws SQLException

Oracle extension. Updates a column with an ORAData value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateCustomDatum

void updateCustomDatum(String columnName,
                       CustomDatum value)
                       throws SQLException

Deprecated.

Oracle extension. Updates a column with an CustomDatum value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateORAData

void updateORAData(String columnName,
                   ORAData value)
                   throws SQLException

Oracle extension. Updates a column with an ORAData value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateDATE

void updateDATE(int columnIndex,
                DATE value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateDATE

void updateDATE(String columnName,
                DATE value)
                throws SQLException

Oracle extension. Updates a column with an oracle.sql.DATE value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateINTERVALYM

void updateINTERVALYM(int columnIndex,
                      INTERVALYM value)
                      throws SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateINTERVALYM

void updateINTERVALYM(String columnName,
                      INTERVALYM value)
                      throws SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALYM value.

Parameters:

columnName - the name of the column to update

value - the new column value

Throws:

SQLException - if a database access error occurs

updateINTERVALDS

void updateINTERVALDS(int columnIndex,
                      INTERVALDS value)
                      throws SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateINTERVALDS

void updateINTERVALDS(String columnName,
                      INTERVALDS value)
                      throws SQLException

Oracle extension. Updates a column with an oracle.sql.INTERVALDS value.

Parameters:

columnName - the name of the columnt to update

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMP

void updateTIMESTAMP(int columnIndex,
                     TIMESTAMP value)
                     throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMP

void updateTIMESTAMP(String columnName,
                     TIMESTAMP value)
                     throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMP value.

Parameters:

columnName - The name of the column to update

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMPTZ

void updateTIMESTAMPTZ(int columnIndex,
                       TIMESTAMPTZ value)
                       throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMPTZ

void updateTIMESTAMPTZ(String columnName,
                       TIMESTAMPTZ value)
                       throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPTZ value.

Parameters:

columnName - the name of the column to update

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMPLTZ

void updateTIMESTAMPLTZ(int columnIndex,
                        TIMESTAMPLTZ value)
                        throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateTIMESTAMPLTZ

void updateTIMESTAMPLTZ(String columnName,
                        TIMESTAMPLTZ value)
                        throws SQLException

Oracle extension. Updates a column with an oracle.sql.TIMESTAMPLTZ value.

Parameters:

columnName - the name of the column to update

value - the new column value

Throws:

SQLException - if a database access error occurs

updateNUMBER

void updateNUMBER(int columnIndex,
                  NUMBER value)
                  throws SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateNUMBER

void updateNUMBER(String columnName,
                  NUMBER value)
                  throws SQLException

Oracle extension. Updates a column with an oracle.sql.NUMBER value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateOracleObject

void updateOracleObject(int columnIndex,
                        Datum value)
                        throws SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateOracleObject

void updateOracleObject(String columnName,
                        Datum value)
                        throws SQLException

Oracle extension. Updates a column with an oracle.sql.xxx value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateRAW

void updateRAW(int columnIndex,
               RAW value)
               throws SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateRAW

void updateRAW(String columnName,
               RAW value)
               throws SQLException

Oracle extension. Updates a column with an oracle.sql.RAW value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateREF

void updateREF(int columnIndex,
               REF value)
               throws SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateREF

void updateREF(String columnName,
               REF value)
               throws SQLException

Oracle extension. Updates a column with an oracle.sql.REF value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateROWID

void updateROWID(int columnIndex,
                 ROWID value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateROWID

void updateROWID(String columnName,
                 ROWID value)
                 throws SQLException

Oracle extension. Updates a column with an oracle.sql.ROWID value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

updateSTRUCT

void updateSTRUCT(int columnIndex,
                  STRUCT value)
                  throws SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnIndex - the first column is 1, the second is 2, ...

value - the new column value

Throws:

SQLException - if a database access error occurs

updateSTRUCT

void updateSTRUCT(String columnName,
                  STRUCT value)
                  throws SQLException

Oracle extension. Updates a column with an oracle.sql.STRUCT value.

Parameters:

columnName - is the SQL name of the column

value - the new column value

Throws:

SQLException - if a database access error occurs

getAuthorizationIndicator

OracleResultSet.AuthorizationIndicator getAuthorizationIndicator(int columnIndex)
                                                                 throws SQLException

Retrieves the column security visibility attribute of the designated column in the current row of this OracleResultSet object.

Throws:

SQLException

getAuthorizationIndicator

OracleResultSet.AuthorizationIndicator getAuthorizationIndicator(String columnName)
                                                                 throws SQLException

Retrieves the column security visibility attribute of the designated column in the current row of this OracleResultSet.

Throws:

SQLException

Skip navigation links