Re: Printing TABS?

From: Mike Ault <mikerault_at_earthlink.net>
Date: 21 Oct 2002 08:50:52 -0700
Message-ID: <37fab3ab.0210210750.288e0cfb_at_posting.google.com>


"Roger Godefroy" <godefroy_at_home.nl> wrote in message news:<ap0hbt$1vv$1_at_news1.tilbu1.nb.home.nl>...
> Hello, I would like to make something similar to the following table. How
> can I make such tabs?
>
> Greetings,
>
> Roger
>
> schaal onder boven aantal 0% 10% 20% 30% 40%
>
> 1 700 1200 3 **********************
>
> 2 1201 1400 3 **********************
>
> 3 1401 2000 2 ***************
>
> 4 2001 3000 5 ************************************
>
> 5 3001 9999 1 ********

A start:

DWPRD>desc test_it

 Name                                      Null?    Type
 ----------------------------------------- -------- -------------------------
 COL1                                               NUMBER

DWPRD>l
  1* select col1, decode(col1,col1,rpad('|',col1+1,'*')) stars from test_it DWPRD>/
       COL1 STARS

---------- ----------------------------------------
         1 |*
         2 |**
         3 |***
         4 |****

4 rows selected.

Mike Received on Mon Oct 21 2002 - 17:50:52 CEST

Original text of this message