dba_rewrite_equivalences
shows rewrite equivalences. This view comes also in the other three variants user_rewrite_equivalences
, all_rewrite_equivalences
and cdb_rewrite_equivalences
. select req.owner, req.name, req.source_stmt, req.destination_stmt, req.rewrite_mode from dba_rewrite_equivalences req;
dbms_advanced_rewrite
.