ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 导出存储程序的源代码

导出存储程序的源代码

原创 Linux操作系统 作者:oracleclub 时间:2011-12-02 08:29:36 0 删除 编辑
用类似的方法导出包,触发器,存储过程等源代码
SQL> conn hr/hr;
Connected.


SQL> select OBJECT_NAME,OBJECT_TYPE,CREATED,STATUS,TEMPORARY 
  2  from user_objects
  3  where OBJECT_TYPE in ('PROCEDURE','FUNCTION');

OBJECT_NAME          OBJECT_TYPE         CREATED   STATUS  T
-------------------- ------------------- --------- ------- -
SECURE_DML           PROCEDURE           29-NOV-11 VALID   N
ADD_JOB_HISTORY      PROCEDURE           29-NOV-11 VALID   N



SQL> desc ADD_JOB_HISTORY--查看参数
PROCEDURE ADD_JOB_HISTORY
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 P_EMP_ID                       NUMBER(6)               IN
 P_START_DATE                   DATE                    IN
 P_END_DATE                     DATE                    IN
 P_JOB_ID                       VARCHAR2(10)            IN
 P_DEPARTMENT_ID                NUMBER(4)               IN

SQL> select line,text from user_source where name = 'ADD_JOB_HISTORY';--查看内容

LINE TEXT
---- --------------------------------------------------------------------------------
   1 PROCEDURE add_job_history
   2   (  p_emp_id          job_history.employee_id%type
   3    , p_start_date      job_history.start_date%type
   4    , p_end_date        job_history.end_date%type
   5    , p_job_id          job_history.job_id%type
   6    , p_department_id   job_history.department_id%type
   7    )
   8 IS
   9 BEGIN
  10   INSERT INTO job_history (employee_id, start_date, end_date,
  11                            job_id, department_id)
  12     VALUES(p_emp_id, p_start_date, p_end_date, p_job_id, p_department_id);
  13 END add_job_history;

13 rows selected.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26465805/viewspace-712591/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-11-22

  • 博文量
    61
  • 访问量
    82243