Question: why do I get two extra empty lines between each selected row?

From: Guang Mei <zlmei_at_hotmail.com>
Date: Fri, 02 Jun 2000 19:25:48 GMT
Message-Id: <10516.107606@fatcity.com>

Hi:

I am try to write some data out from an oracle db to a text file. When I run the code sql worksheet, everything works fine. But when I run it in sql/plus I always got two extra empty lines between each selected rows. I am curious why it happened. The total length of each selected row is 1840 bytes. The two extra "empty" lines also both are 1840 bytes.

Here is the code:

---

set heading off feedback off verify off pause off set pagesize 0
set linesize 1840
set colsep '' -- so that there is no column separator. default is a single space

spool e:\GuangMei_work\product_out.txt;

Select
SKU
,HPXPRODUCT.SHORTNAME
,HPXMANUFACTURER.SHORTNAME
,HPXCATEGORY.SHORTNAME
,UPCCode
,UOM
,TYPECODE
,kosher_info.LONGNAME
,BRAND
,PACKAGING
,ITEMSIZE
,AVGWEIGHT
,VISIBLE
,HIGHFIBER
,VALUEPACK
,SPECIALORDER
,HOUSECHEFENDORSED
,HOUSEBRAND
,SEASONAL
,HOLIDAY
,ORGANIC
,RIPE
,VEGETARIAN
,VEGAN
,MACROBIOTIC
,NOFAT
,LOWFAT
,HEARTHEALTHY
,NOSUGAR
,LOWSUGAR
,NOSALT
,LOWSALT
,LOWCHOLESTEROL
,LOWCALORIE
,ASPARTAMEFREE
,SACCHARINFREE
,DAIRYFREE
,EGGFREE
,PEANUTFREE
,WHEATFREE
,GLUTENFREE
,SOYFREE
,PHENYLALANINEFREE
,CALORIES
,FATCONTENT
,SODIUMCONTENT
,SUGARCONTENT
,CHOLESTEROLCONTENT
,PROTEINCONTENT
,HPXPRODUCT.LONGNAME
,MESSAGETEXT
,INGREDIENTS

from HPXPRODUCT,

     HPXMANUFACTURER,
     HPXUPC,
     HPXUOMCode,

    HPXProductCategory,
    HPXCategory,
    Kosher_info
where HPXPRODUCT.MANUFACTURERID = HPXMANUFACTURER.MANUFACTURERID

and     HPXPRODUCT.ProductID = HPXUPC.ProductID
and     HPXPRODUCT.UOMID = HPXUOMCode.UOMID
and     HPXPRODUCT.ProductID = HPXProductCategory.ProductID
and     HPXProductCategory.CategoryID = HPXCategory.CategoryID
and     HPXPRODUCT.Kosher = Kosher_info.KOSHER_CODE_NUMBER

and rownum<4
order by HPXPRODUCT.sku;

spool off;

---

• The spooled result, sorry for the empty lines taking spaces here:

4211        NanNec Half & Half            Nantucket Nectars             Iced 
Teas/Lemonades           72628416504         oz                          1OU 
                                                                             
                                     17.5         T FF                       
                                                                             
     Nantucket Nectars Half and Half Juice Drink (Lemonade and Iced Tea)


4212        NanNec Orange Mango           Nantucket Nectars             
Fruit Juices/Drinks           72628417512         oz                         
  1OU                                                                        
                                          17.5         T FF                  
                                                                             
          Nantucket Nectars Orange Mango Juice Cocktail


4213        NanNec Lemonade               Nantucket Nectars             
Fruit Juices/Drinks           72628416501         oz                         
  1OU                                                                        
                                          17.5         T FF                  
                                                                             
          Nantucket Nectars Authentic Lemonade                               
                                  ----------------

Anybody has any suggestions?

Thanks.

---

Received on Fri Jun 02 2000 - 14:25:48 CDT