FROM user_source us
ORDER BY us.name, us.type;
BEGIN
FOR cur_source_programs_row IN cur_source_programs
LOOP
dbms_output.put_line(''''spool export\'''' || user || ''''_'''' || cur_source_programs_row.spool_file);
dbms_output.put_line(''''@extract_source '''' || cur_source_programs_row.name || '''' "'''' || cur_source_programs_row.type || ''''"'''');
dbms_output.put_line(''''spool off'''');
END LOOP;
END;
/
SPOOL OFF
@temp_source_extract
SET FEEDBACK ON VERIFY ON TERMOUT ON
PROMPT Export complete!
PROMPT
Extract_source.sql:
SET HEAD OFF VERIFY OFF
prompt --************************************************************************************--;
prompt --*;
prompt --*
上一页 [1] [2] [3] [4] [5] 下一页
Copyright @ 2007-2012 敏韬网(敏而好学,文韬武略--MinTao.Net)(学习笔记) Inc All Rights Reserved. 闵涛 E_mail:admin@mintao.net(欢迎提供学习资源)
鄂公网安备 42011102001154号
站长:MinTao ICP备案号:鄂ICP备11006601号-18