8-18. Built-in Packages

  • DBMS_STATS: Gather, view, and modify optimizer statistics
  • DBMS_OUTPUT: Generate output from PL/SQL
  • DBMS_SESSION: PL/SQL access to the ALTER SESSION and SET ROLE statements
  • DBMS_RANDOM: Generate random numbers
  • DBMS_UTILITY: Get time, CPU time, and version information; compute a hash value, and perform many other miscellaneous functionalities
  • DBMS_SCHEDULER: Schedule functions and procedures that are callable from PL/SQL
  • DBMS_CRYPTO: Encrypt and decrypt database data
  • UTL_FILE: Read and write to operating system files from PL/SQL

April 1, 2008. Packages. Leave a comment.