--查看所有某用户下存储过程 SQL>select * from All_Objects where owner='YOURUSER' and object_type='PROCEDURE';--查看某一用户下某一具体存储过程 SQL>select name,line,text from all_source where owner='YOURUSER' and type='PROCEDURE' and name='PRODNAME';--其中name为存储过程的名字,type是类型,owner是所有者
SQL>select * from All_Objects
where owner='YOURUSER' and object_type='PROCEDURE';--查看某一用户下某一具体存储过程
SQL>select name,line,text from all_source
where owner='YOURUSER' and type='PROCEDURE' and name='PRODNAME';--其中name为存储过程的名字,type是类型,owner是所有者
where owner='YOURUSER'
and type='PROCEDURE'
and name='PRODNAME'
and text like '%tb_abc%';不知道这样可以么?
where owner='YOURUSER'
and type='PROCEDURE'
and text like '%tb_abc%';
导出所有.sql文件