Re: Printing TABS?
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