我在sql plus worksheet里输入:
spool off
spool d:\result.txt
set linesize 10000
select ' area:'||ltrim(rtrim(area_1))||ltrim(rtrim(area_2)),
' type:'||ltrim(rtrim(type_1))||ltrim(rtrim(type_2)),
' ename:'||ltrim(rtrim(ename)),
' phone:'||ltrim(rtrim(phone)),
' fax:'||ltrim(rtrim(fax)),
' saddr:'||ltrim(rtrim(saddr)),
' email:'||ltrim(rtrim(email)),
' surl:'||ltrim(rtrim(surl)),
' postcode:'||ltrim(rtrim(postcode)),
' sdetail:'||ltrim(rtrim(sdetail))
from tbl_114_companyinfo
where rownum<11;
谁知,在d:\result.txt里有大量的下列字符:
'AREA:'||LTRIM(RTRIM(AREA_1))||LTRIM(RTRIM(AREA_2)) 'TYPE:'||LTRIM(RTRIM(TYPE_1))||LTRIM(RTRIM(TYPE_2)) 'ENAME:'||LTRIM(RTRIM(ENAME)) 'PHONE:'||LTRIM(RTRIM(PHONE)) 'FAX:'||LTRIM(RTRIM(FAX)) 'SADDR:'||LTRIM(RTRIM(SADDR))
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
'EMAIL:'||LTRIM(RTRIM(EMAIL)) 'SURL:'||LTRIM(RTRIM(SURL)) 'POSTCODE:'||LTRIM( 'SDETAIL:'||LTRIM(RTRIM(SDETAIL))
------------------------------------------------------------------------------------------------------
要怎么才能去掉那些不要的东东,而只要查询数据?
请教请教。
另:前一段时间问过该问题,给高手解答了,但我的电脑坏了重装后,那些脚本也没了。故再一次请教.
谢谢先!