formatting in SQLPLUS

From: Suhen Pather <Suhen.Pather_at_strandbags.com.au>
Date: Sun, 03 Feb 2002 16:07:14 -0800
Message-ID: <F001.004045A4.20020203154517@fatcity.com>

<span style='font-size:10.0pt;

font-family:Arial'>List,

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>I am creating a report via sqlplus.

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>I am working with the formatting.<span style='mso-spacerun:yes'>  When I run the report it puts the headings

<span

style='font-size:10.0pt;font-family:Arial'>for<font face=Arial> the columns after every 2 rows of the report.  I would like to have the
headings at the top of the report

<span

style='font-size:10.0pt;font-family:Arial'>only<font face=Arial>.

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>I could set the heading off but it would give me no headings at all.

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>Here is an eg.

<span style='font-size:10.0pt;

font-family:Arial'> 

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>            PONO SKU<span
style='mso-spacerun:yes'>     SKU_DESC<span
style='mso-spacerun:yes'>                            QTY RCV_SESS_NO

RCT_DATE    
<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007084 EQUIP HS EW BUCK TOTE Black         450<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007085 EQUIP HS NS BUCK TOTE Black         800<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>         <span
style='mso-spacerun:yes'>   PONO SKU    
SKU_DESC                           
QTY RCV_SESS_NO RCT_DATE     

<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007088 EQUIP HS SM BUCK TOTE Black         750<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007089 EQUIP NYLON BKL NS ZT Black         650<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>            PONO SKU<span
style='mso-spacerun:yes'>     SKU_DESC<span
style='mso-spacerun:yes'>                            QTY RCV_SESS_NO

RCT_DATE    
<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007090 EQUIP NYLON BKL EW ZT Black         650<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>            PONO SKU<span
style='mso-spacerun:yes'>     SKU_DESC<span
style='mso-spacerun:yes'>           <span
style='mso-spacerun:yes'>                 QTY RCV_SESS_NO RCT_DATE<span
style='mso-spacerun:yes'>     

<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007091 EQUIP NYLON BKL LG EW ZT Black      600<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007092 EQUIP HS CHAIN FOVER Black          750<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>            PONO SKU<span
style='mso-spacerun:yes'>     SKU_DESC<span
style='mso-spacerun:yes'>                            QTY RCV_SESS_NO

RCT_DATE    
<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007093 EQUIP HS CHAIN FOVER Caramel        750<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<span

class=GramE><span style='font-size:10.0pt; font-family:"Courier New"'>GNO  GNAME<font face="Courier New"><span

style='mso-spacerun:yes'>            PONO SKU<span
style='mso-spacerun:yes'>     SKU_DESC<span
style='mso-spacerun:yes'>                            QTY RCV_SESS_NO

RCT_DATE    
<font

size=2 face="Courier New">----

---------- ---------- ------- --------------------------------- -----

----------- ---------   

<font

size=2 face="Courier New">01<span
style='mso-spacerun:yes'>   Handbags<span style='mso-spacerun:yes'>       209002 3007094 EQUIP SATIN EW HOBO Black          1000<span
style='mso-spacerun:yes'>     1795246 <st1:date Month="2" Day="4" Year="2002">04-FEB-02<font
face="Courier New"><span
style='mso-spacerun:yes'>   

<font

size=2 face="Courier New"> 

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>Any help with be appreciated

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>Thanks

<span style='font-size:10.0pt;

font-family:Arial'>$uhen

<span style='font-size:10.0pt;

font-family:Arial'> 

<span style='font-size:10.0pt;

font-family:Arial'>  Received on Sun Feb 03 2002 - 18:07:14 CST