Oracle-拼接字段

select 'update chengshi set xzq_id =' || xzq_id || ' where id = ' || id || ';' 
  from chengshi;

select 'alter system kill session'||' '||''''||s.sid||','||s.serial#||''''||';',v$sql.sql_text
  from v$process,v$session s,v$sql
 where addr = paddr
   and s.sql_id = v$sql.sql_id
   and sql_hash_value = hash_value;