dsp.pks.txt

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

CREATE OR REPLACE PACKAGE dsp AS
-- --------------------------------------------------------------------------
-- Name         : dsp.pks
-- Author       : DR Timothy S Hall
-- Description  : An extension of the DBMS_OUTPUT package.
-- Requirements : dsp.pkb
-- Ammedments   :
--   When         Who       What
--   ===========  ========  =================================================
--   08-JAN-2002  Tim Hall  Initial Creation
-- --------------------------------------------------------------------------

  PROCEDURE reset_defaults;

  PROCEDURE show_output_on;
  PROCEDURE show_output_off;
  
  PROCEDURE show_date_on;
  PROCEDURE show_date_off;

  PROCEDURE line_wrap_on;
  PROCEDURE line_wrap_off;

  PROCEDURE set_max_width (p_width IN NUMBER);

  PROCEDURE set_date_format (p_date_format IN VARCHAR2);
  
  PROCEDURE file_output_on (p_file_dir  IN VARCHAR2 DEFAULT NULL,
                            p_file_name IN VARCHAR2 DEFAULT NULL);
                            
  PROCEDURE file_output_off;
                            
  PROCEDURE line (p_data   IN VARCHAR2);
  PROCEDURE line (p_data   IN NUMBER);
  PROCEDURE line (p_data   IN BOOLEAN);
  PROCEDURE line (p_data   IN DATE,
                  p_format IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS');
  
  PROCEDURE line (p_prefix IN VARCHAR2,
                  p_data   IN VARCHAR2);
  PROCEDURE line (p_prefix IN VARCHAR2,
                  p_data   IN NUMBER);
  PROCEDURE line (p_prefix IN VARCHAR2,
                  p_data   IN BOOLEAN);
  PROCEDURE line (p_prefix IN VARCHAR2,
                  p_data   IN DATE,
                  p_format IN VARCHAR2 DEFAULT 'DD-MON-YYYY HH24:MI:SS');

END dsp;
/

SHOW ERRORS