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: