工具代码：

export_source.sql

SET SERVEROUTPUT ON SIZE 1000000

SET ECHO OFF VERIFY OFF FEEDBACK OFF TRIMSPOOL ON PAGES 0 LINES 512

SET TERMOUT OFF

SET TERMOUT ON

PROMPT

PROMPT PL/SQL export utility

PROMPT

PROMPT This utilty exports all of the current schema''''s PL/SQL source code into

PROMPT a subdirectory called export.

PROMPT

PROMPT Exporting current user''''s source to folder ./export

SET TERMOUT OFF

SPOOL temp_source_extract.sql

PROMPT SET ECHO OFF VERIFY OFF FEEDBACK OFF TRIMSPOOL ON TERMOUT OFF PAGES 0 LINES 512

DECLARE

    /*

    || This cursor extracts each PL/SQL stored procedure''''s name and procedure type

    */

    CURSOR cur_source_programs

    IS

        SELECT    distinct us.name, us.type,

                  us.name || decode(us.type, ''''PACKAGE'''',      ''''.PKS'''',

                                             ''''PACKAGE BODY'''', ''''.PKB'''',

上一页  [1] [2] [3] [4] [5]  下一页