⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 dsp.pks.txt

📁 oracle dba 常用的管理脚本, 覆盖日常的系统管理.
💻 TXT
字号:
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

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -