Oracle PL/SQL Programming, 2nd Edition

Previous: C.3 Oracle AQ, the Advanced Queueing Facility Appendix C
Built-In Packages Next: C.5 DBMS_ JOB

C.4 DBMS_DDL

The DBMS_DDL package provides access to some of the SQL DDL statements from within stored procedures.

C.4.1 The ALTER_COMPILE procedure

The ALTER_COMPILE procedure can be used to programmatically force a recompile of a stored object. The specification is:

PROCEDURE DBMS_DDL.ALTER_COMPILE
 (type VARCHAR2,
 schema VARCHAR2,
 name VARCHAR2);

C.4.2 The ANALYZE_OBJECT procedure

A call to ANALYZE_OBJECT lets you programmatically compute statistics for the specified object. The specification is:

PROCEDURE DBMS_DDL.ANALYZE_OBJECT
 (type VARCHAR2,
 schema VARCHAR2,
 name VARCHAR2,
 method VARCHAR2,
 estimate_rows NUMBER DEFAULT NULL,
 estimate_percent NUMBER DEFAULT NULL);

Previous: C.3 Oracle AQ, the Advanced Queueing Facility Oracle PL/SQL Programming, 2nd Edition Next: C.5 DBMS_ JOB

C.3 Oracle AQ, the Advanced Queueing Facility Book Index C.5 DBMS_ JOB

The Oracle Library Navigation

(追記) (追記ここまで)