schema的常用脚本:getallcode.sql
添加时间: 2008-4-21 23:47:38 作者: Oracle指导 阅读次数:10 来源: http://www.d9soft.com
set termout off
set heading off
set feedback off
set linesize 50
spool xtmpx.sql
select '@getcode ' || object_name
from user_objects
where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE' )
/
spool off
spool getallcode_INSTALL.sql
select '@' || object_name
from user_objects
where object_type in ( 'PROCEDURE', 'FUNCTION', 'PACKAGE' )
/
spool off
set heading on
set feedback on
set linesize 130
set termout on
@xtmpx.sql
上下文章:
上一篇文章: Oracle游标使用大全 下一篇文章: schema的常用脚本:show