Oracle For Unix

export ORACLE_HOME=/opt/oracle/product/10.2.0
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=$ORACLE_HOME/bin:$PATH

sqlplus -S -M "HTML ON TABLE 'BORDER="2"'" user/passwd@dbname @c:\a.txt > c:\a.html
set longchunksize 13000
set long 13000
set linesize 15000
select long_desc from content where rownum <10 and long_desc is not null and rownum < 10;
exit