Re: What are the #'s in where n.statistic# = b.statistic#?

The column name is statistic#

Hth,

Sybrand Bakker, oracle DBA

Ken Sproule <kenmn_at_tds.net> wrote in message news:qsovcs0r8noe14mnhi01vqnv1l7i30sc63_at_4ax.com...
> Thanks for everyone's help!
>
> This is a code snippet from Oracle's DBA Handbook CD. I have looked
> everywhere and can't determine what the #'s in this table creation
> statement are doing. Any one know?
>
> create table stats$stats as
> select e.value-b.value change , n.name
> from v$statname n , stats$begin_stats b , stats$end_stats e
> where n.statistic# = b.statistic# and n.statistic# =
> e.statistic#;
>
>
> Best,
>
> Ken Sproule
> kenmn_at_tds.net
>
>
> Ken Sproule
> kenmn_at_tds.net
Received on Wed Mar 15 2000 - 00:00:00 CST