| ''''.SQL'''') spool_file
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] 下一页 | 
