 |
|
DBMS_ADVANCED_REWRITE package tips
Oracle Tips by Burleson Consulting |
DBMS_ADVANCED_REWRITE
<< Return to the index
Related notes on DBMS_ADVANCED_REWRITE:
Oracle 11g provides the following information about the DBMS_ADVANCED_REWRITE package:
Description of the DBMS_ADVANCED_REWRITE package:
PROCEDURE DBMS_ADVANCED_REWRITE.ALTER_REWRITE_EQUIVALENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
REWRITE_MODE VARCHAR2 IN
PROCEDURE DBMS_ADVANCED_REWRITE.BUILD_SAFE_REWRITE_EQUIVALENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
SOURCE_STMT CLOB IN
DESTINATION_STMT CLOB IN
CHECK_SUM BINARY_INTEGER IN
PROCEDURE DBMS_ADVANCED_REWRITE.DECLARE_REWRITE_EQUIVALENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
SOURCE_STMT CLOB IN
DESTINATION_STMT CLOB IN
VALIDATE BOOLEAN IN DEFAULT
REWRITE_MODE VARCHAR2 IN DEFAULT
PROCEDURE DBMS_ADVANCED_REWRITE.DROP_REWRITE_EQUIVALENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
PROCEDURE DBMS_ADVANCED_REWRITE.VALIDATE_REWRITE_EQUIVALENCE
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
NAME VARCHAR2 IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
