查找存过信息
select * from dba_procedures where object_type='PROCEDURE' and object_name='存过名'
查看存过内容
SELECT text FROM all_source WHERE TYPE='PROCEDURE' and NAME = '存过名' ORDER BY line
查找序列
select * from dba_sequences where sequence_name='序列名'
查找存过信息
select * from dba_procedures where object_type='PROCEDURE' and object_name='存过名'
查看存过内容
SELECT text FROM all_source WHERE TYPE='PROCEDURE' and NAME = '存过名' ORDER BY line
查找序列
select * from dba_sequences where sequence_name='序列名'