Path: utzoo!attcan!uunet!decwrl!elroy.jpl.nasa.gov!usc!cs.utexas.edu!ut-emx!linus!roadrunner!susan From: susan@roadrunner.slcs.slb.com (Susan Rosenbaum) Newsgroups: comp.databases Subject: Oracle Question Message-ID: <8601@linus.SLCS.SLB.COM> Date: 26 Jul 90 15:13:09 GMT Sender: news@linus.SLCS.SLB.COM Lines: 16 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! Susan Rosenbaum e-mail: rosenbaum@slcs.slb.com Schlumberger Laboratory for Computer Science phone: 1 512-331-3759 Austin, Texas fax: 1 512-331-3760