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

"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