The s$ prefix is used to retrieve system
values.
The following table presents and briefly describes these
values.
Table 1. Descriptions of system values
| Prefix and Value |
Data Type |
Description |
| s$entry |
NUMBER |
Represents the entry point from where the
stored procedure was invoked. You can invoke a stored procedure from
the following entry points:
- 1
- Indicates that the stored procedure was invoked before a table
clear (truncate) operation.
- 2
- Indicates that the stored procedure was invoked after a table
clear (truncate) operation.
- 3
- Indicates that the stored procedure was invoked before a row insert
operation.
- 4
- Indicates that the stored procedure was invoked after a row insert
operation.
- 5
- Indicates that the stored procedure was invoked before a row update
operation.
- 6
- Indicates that the stored procedure was invoked after a row update
operation.
- 7
- Indicates that the stored procedure was invoked before a row delete
operation.
- 8
- Indicates that the stored procedure was invoked after a row delete
operation.
- 9
- Indicates that the stored procedure was invoked before a table
refresh operation.
- 10
- Indicates that the stored procedure was invoked after a table
refresh operation.
|
| s$srcSysId |
VARCHAR |
Identifies uniquely the location of the source
data. |
| s$srcTabId |
VARCHAR |
Represents the name of the source table in the
source database that sends replicated data to the target. |
| s$tgtTabId |
VARCHAR |
Represents the name of the target table in the
target database that receives replicated data from the source. |