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

From: <gmei_at_my-deja.com>
Date: 2000/06/02
Message-ID: <8h97bc$9e7$1@nnrp1.deja.com>#1/1

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.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Jun 02 2000 - 00:00:00 CDT