Path: utzoo!attcan!uunet!bu.edu!rpi!zaphod.mps.ohio-state.edu!wuarchive!emory!mephisto!prism!re4
From: re4@prism.gatech.EDU (RUSSELL EARNEST)
Newsgroups: comp.databases
Subject: Re: Oracle Question
Summary: Use SQL*Report Writer
Message-ID: <11845@hydra.gatech.EDU>
Date: 26 Jul 90 17:26:25 GMT
References: <8601@linus.SLCS.SLB.COM>
Organization: Georgia Institute of Technology
Lines: 23

In article <8601@linus.SLCS.SLB.COM>, susan@roadrunner.slcs.slb.com (Susan Rosenbaum) writes:
> I have an Oracle database containing address information.  What I want
> to do is print the addresses onto two-column formatted mailing labels.
> For example,
> 	Joe Smith			Jane Jones
> 	111 Main St.			222 First St.
> 	Yourtown, Tx. 99999 		Yourcity, Tx. 88888
> Does anyone know the magic incantation from SQL*Plus to format the
> responses from a database query in this manner?  Thanks!

I think what you are looking for is in the SQL*Report Writer package not
SQL*Plus.

Page 4-9 of the Introduction to SQL*Report Writer manual (#19678-0688)
describes a mailing label report laid out exactly as you describe.

Enjoy.

-- 
Any similarity between this comment and rational thought is purely coincidental.
 - RUSSELL EARNEST     Georgia Institute of Technology, Atlanta Georgia, 30332
uucp: ...!{allegra,amd,hplabs,seismo,ut-ngp}!gatech!prism!re4
ARPA: re4@prism.gatech.edu