1.

Give The Usage Of Dbms_ddl Package ?

Answer»

The DBMSJDDL package provides access to CERTAIN DDL STATEMENTS within PL/SQL blocks. This package runs with the privileges of the CALLING user and not the OWNER of the SYS package. Some of the procedures included in this package are as follows:

  •  DBMS_DDL.ALTER_COMPILE object_type, owner, object__name)
  •  DBMS_DDL.ANALYZE_OBJECT(object_type, owner, object_name, method)

The DBMSJDDL package provides access to certain DDL statements within PL/SQL blocks. This package runs with the privileges of the calling user and not the owner of the SYS package. Some of the procedures included in this package are as follows:


Discussion

No Comment Found

Related InterviewSolutions