| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_REWRITE_EQUIVALENCES describes the rewrite equivalences accessible to the current user.
DBA_REWRITE_EQUIVALENCES describes all rewrite equivalences in the database.
USER_REWRITE_EQUIVALENCES describes the rewrite equivalences owned by the current user.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
OWNER | 
VARCHAR2(30) | 
NOT NULL | 
Owner of the rewrite equivalence | 
NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of the rewrite equivalence | 
SOURCE_STMT | 
CLOB | 
Source statement of the rewrite equivalence | |
DESTINATION_STMT | 
CLOB | 
Destination of the rewrite equivalence | |
REWRITE_MODE | 
VARCHAR2(10) | 
Rewrite mode of the rewrite equivalence:
  |