oracle 一般拼接方法整理

1.spool方式

set heading off
set feedback off
spool dropseq.sql
select 'drop sequence '||SEQUENCE_OWNER||'.'||sequence_name||';' from dba_sequences where SEQUENCE_OWNER='SYS';
spool off

2.listagg方式

col name for a20
select 'alter database tempfile'||''''||listagg(file_name,''',''')||''''||' resize 32G'||';' from dba_temp_files where autoextensible='YES';

3.