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

From: PaulCinVT <paulcinvt_at_aol.com>
Date: 20 Mar 2000 13:45:35 GMT
Message-ID: <20000320084535.03575.00004390@nso-ch.aol.com>

>>

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#;
<<

It is the column name...

SQL> desc v$statname

 Name                            Null?    Type
 ------------------------------- -------- ----
 STATISTIC#                               NUMBER
 NAME                                     VARCHAR2(64)
 CLASS                                    NUMBER

Paul in VT Received on Mon Mar 20 2000 - 07:45:35 CST