sqlplus / as sysdba
set long 9999
set pagesize 0
select TEXT from dba_source WHERE type='PROCEDURE' AND OWNER=upper('用户名') AND NAME=
upper('存储过程名字');
select * from dba_source WHERE type='TYPE' AND OWNER=upper('用户名') AND NAME='类型名称'; --导出类型的语句
sqlplus / as sysdba
set long 9999
set pagesize 0
select TEXT from dba_source WHERE type='PROCEDURE' AND OWNER=upper('用户名') AND NAME=
upper('存储过程名字');
select * from dba_source WHERE type='TYPE' AND OWNER=upper('用户名') AND NAME='类型名称'; --导出类型的语句