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

Hi, Ken:

The #'s don't "do" anything. They are part of the column names.

                                    Rick

Ken Sproule <kenmn_at_tds.net> writes:

> 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

--

                                Thanks,
                                Rick
                                Rick Wessman
                                Server Security Group
                                Oracle Corporation
                                rwessman_at_us.oracle.com

     The opinions expressed above are mine and do not necessarily reflect
                         those of Oracle Corporation.