如何获得trigger的脚本？如何获得表的脚本，如何获得包的脚本？

Question

建议你使用PL/SQL Developer软件，使用那个软件能方便地到处存储过程和表的脚本。

Answer 1

包：
SQL> select distinct type from user_source;TYPE
------------
FUNCTION
PACKAGE
PACKAGE BODY
PROCEDURE
TYPETYPE = 'PACKAGE BODY'  / TYPE = 'PACKAGE' Trigger:
SQL> desc user_triggers;
 名称                                      空?      类型
 ----------------------------------------- -------- ----------------------------
 TRIGGER_NAME                                       VARCHAR2(30)
 TRIGGER_TYPE                                       VARCHAR2(16)
 TRIGGERING_EVENT                                   VARCHAR2(216)
 TABLE_OWNER                                        VARCHAR2(30)
 BASE_OBJECT_TYPE                                   VARCHAR2(16)
 TABLE_NAME                                         VARCHAR2(30)
 COLUMN_NAME                                        VARCHAR2(4000)
 REFERENCING_NAMES                                  VARCHAR2(128)
 WHEN_CLAUSE                                        VARCHAR2(4000)
 STATUS                                             VARCHAR2(8)
 DESCRIPTION                                        VARCHAR2(4000)
 ACTION_TYPE                                        VARCHAR2(11)
 TRIGGER_BODY                                       LONG