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

Ken Sproule wrote:
>
> 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

They are simply the column names - if you DESCRIBE any of the tables you will find that the columns contain the #.

I think Oracle puts them there to make them harder to type :-)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse