MINE_VALUE Function

This function returns the value contained in the first parameter corresponding to the column name indicated in the second parameter.

The syntax for this function is as follows:

Syntax

dbms_logmnr.mine_value(
     sql_redo_undo        IN  RAW,
     column_name        IN  VARCHAR2 default '') RETURN VARCHAR2;

Parameters

The parameters for the MINE_VALUE function are listed in Table 24-4.

Table 24-4 MINE_VALUE Function Parameters

Parameter	Description
sql_redo_undo	Value of the REDO_VALUE or UNDO_VALUE columns selected from V$LOGMNR_CONTENTS. The value of this parameter directs LogMiner to return undo or redo column information. This parameter can be thought of as a self-describing record that contains values corresponding to several columns in a table.
column_name	Fully qualified column name (schema.table.column) which this function will return information about.

Returns

Table 24-5 Return Values for MINE_VALUE Function

Return	Description
NULL	The column is not contained within the self-describing record or the column value is NULL.
NON-NULL	The column is contained within the self-describing record; the value is returned in string format.

Exceptions

No LogMiner errors are returned.

Usage Notes

• To use the MINE_VALUE function, you must have successfully started a LogMiner session.

• The MINE_VALUE function must be invoked in the context of a select operation from the V$LOGMNR_CONTENTS view.

• The MINE_VALUE function does not support LONG, LOB, ADT, or COLLECTION datatypes.