Oracle PL/SQL Programming, 2nd Edition

Oracle PL/SQL Programming, 2nd EditionSearch this book
Previous: C.3 Oracle AQ, the Advanced Queueing FacilityAppendix 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 FacilityOracle PL/SQL Programming, 2nd EditionNext: C.5 DBMS_  JOB
C.3 Oracle AQ, the Advanced Queueing FacilityBook IndexC.5 DBMS_ JOB

The Oracle Library Navigation

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference