SET NEWPAGE NONE SET PAGESIZE 0 SET SPACE 0 SET LINESIZE 16000 SET ECHO OFF SET FEEDBACK OFF SET VERIFY OFF SET HEADING OFF SET TERMOUT OFF SET TRIMOUT ON SET TRIMSPOOL ON SET COLSEP | spool &1..txt @@&1 spool off exit I then call SQL*Plus passing the actual SQL script I want to run as an argument: sqlplus -S user/password@database @dump.sql my_real_query.sql The result is written to a file my_real_query.sql.txt set wrap off set linesize 3000 // or something very large SET ECHO OFF SET SERVEROUTPUT ON SIZE 1000000 SET PAGESIZE 999 set wrap off set linesize 3000 // or something very large
воскресенье, 2 февраля 2014 г.
exec sql plus in useful manner
Подписаться на:
Комментарии к сообщению (Atom)
cat run_main.sh
ОтветитьУдалитьnohup sqlplus main/main@db_main @dump.sql $1 &