Oracle SPOOL用法

 

SET LINESIZE 1000

SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 0

SET HEADING OFF

SET TRIMS ON

SET SERVEROUTPUT ON

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

WHENEVER SQLERROR EXIT;

--?建sequence?句

SPOOL E:\xrd\00.creatsequence\SEQUENCE.SQL

--PROMPT "CREATSEQUENCE"

select 'create sequence '||sequence_name||    

       ' minvalue '||min_value||    

       ' maxvalue '||max_value||    

       ' start with '||last_number||    

       ' increment by '||increment_by||    

       (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'   

from dba_sequences 

where sequence_owner='GTMC_PKG1';

SPOOL OFF

EXIT

SET LINESIZE 1000

SET TERM OFF VERIFY OFF FEEDBACK OFF PAGESIZE 0

SET HEADING OFF

SET TRIMS ON

SET SERVEROUTPUT ON

ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

WHENEVER SQLERROR EXIT;

--?建sequence?句SPOOL 

E:\xrd\00.creatsequence\SEQUENCE.SQL

--PROMPT "CREATSEQUENCE"

select 'create sequence '||sequence_name||           

' minvalue '||min_value||          

 ' maxvalue '||max_value||           

' start with '||last_number||           

' increment by '||increment_by||          

 (case when cache_size=0 then ' nocache' else ' cache '||cache_size end) ||';'   

from dba_sequences 

where sequence_owner='GTMC_PKG1';

SPOOL OFF

EXIT