Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'monitoring' keyword as table name

'monitoring' keyword as table name

From: marco.nierlich <marco.nierlich_at_swissguide.ch>
Date: 26 Feb 2007 03:29:43 -0800
Message-ID: <1172489383.693954.54110@k78g2000cwa.googlegroups.com>


Hi all

We're on 8.1.5 and external developers added a new table named 'monitoring' to our database. Now, We're facing a phenomenon where we don't have an explanation:

SQL> select sum(m.visits_today) from monitoring m;

SUM(M.VISITS_TODAY)


            2588115

SQL> select sum(m.visits_total) from monitoring m;

SUM(M.VISITS_TOTAL)


           13415014

SQL> select sum(m.visits_today + m.visits_today) from monitoring m;

SUM(M.VISITS_TODAY+M.VISITS_TODAY)


                           5176252


Anyone with an explanation?
TIA
Marco Received on Mon Feb 26 2007 - 05:29:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US