Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: How to print field/value at specific column without using spaces??

Re: PL/SQL: How to print field/value at specific column without using spaces??

From: Jeff Smith <jsmit234>
Date: Thu, 19 Jun 2003 15:39:01 -0400
Message-ID: <bct3gl$svh15@eccws12.dearborn.ford.com>


Tab is chr(9), and it will work.

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:vf1impjjaqn0de_at_corp.supernews.com...
>
> "george lewycky" <gelewyc_at_nyct.com> wrote in message
> news:68aecc05.0306181051.5470ea83_at_posting.google.com...
> > Hi
> >
> > I'm using dbms_output.put_line to format some output
> > but I cant seem to find a "simpler" way of printing the
> > text, etc. at a specific column or location without
> > adding spaces as I show below:
> >
> > dbms_output.put_line('- Brooklyn, NY 11201 ');
> >
> >
> > This is similiar to using TAB in BASIC, or PIC in COBOL
> >
> >
> > Any ideas or alternatives woud be appreciated
> >
> > Thanks
> >
> > George
>
> tab would mean simply using chr(8). Have you ever tried it? Can't see a
> reason why it wouldn't work.
> Of course you could also use lpad(<expression>,number) to get identical
> results.
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
>
>
Received on Thu Jun 19 2003 - 14:39:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US