informix数据库迁移到oracle10g
unload to 'data/aaa.dat' delimiter '^G' select
accbankid
,bal
,begintime
,branid
,corpid
,replace(corpname,'
','$^$')
,replace(custaddr,'
','$^$')
,custid
,replace(custname,'
','$^$')
,duedays
,loanacno
,loantype
,paperid
,paperkind
,province
,rundate
,replace(scharea,'
','$^$')
,schid
,studcode
from aaa
使用replace来对换行做处理,但是如何判断一个表的某个字段换行了呢?请指教
页:
[1]