OracleResultSet (Oracle Database JDBC Java API Reference)

All Superinterfaces:

AutoCloseable, 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

Nested Classes
Modifier and Type Interface and Description

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

Nested Classes
Modifier and Type	Interface and Description
`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

All Methods Instance Methods Abstract Methods Deprecated Methods
Modifier and Type	Method and Description
`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, 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, 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

Interface OracleResultSet

Nested Class Summary

Field Summary

Fields inherited from interface java.sql.ResultSet

Method Summary

Methods inherited from interface java.sql.ResultSet

Methods inherited from interface java.sql.Wrapper

Method Detail

getARRAY

getARRAY

getBfile

getBFILE

getBfile

getBFILE

getBLOB

getBLOB

getCHAR

getCHAR

getCLOB

getCLOB

getOPAQUE

getOPAQUE

getINTERVALYM

getINTERVALYM

getINTERVALDS

getINTERVALDS

getTIMESTAMP

getTIMESTAMP

getTIMESTAMPTZ

getTIMESTAMPTZ

getTIMESTAMPLTZ

getTIMESTAMPLTZ

getCursor

getCursor

getCustomDatum

getORAData

getObject

getObject

getCustomDatum

getORAData

getDATE

getDATE

getNUMBER

getNUMBER

getOracleObject

getOracleObject

getRAW

getRAW

getREF

getREF

getROWID

getROWID

getSTRUCT

getSTRUCT

updateARRAY

updateARRAY

updateBfile

updateBFILE

updateBfile

updateBFILE

updateBLOB

updateBLOB

updateCHAR

updateCHAR

updateCLOB

updateCLOB

updateCustomDatum

updateORAData

updateCustomDatum

updateORAData

updateDATE

updateDATE

updateINTERVALYM

updateINTERVALYM

updateINTERVALDS

updateINTERVALDS

updateTIMESTAMP

updateTIMESTAMP

updateTIMESTAMPTZ

updateTIMESTAMPTZ