ALL_REWRITE_EQUIVALENCES

ALL_REWRITE_EQUIVALENCES describes the rewrite equivalences accessible to the current user.

Related Views

  • 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:

  • DISABLED

  • TEXT_MATCH

  • GENERAL

  • RECURSIVE

See Also: