Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 'monitoring' keyword as table name
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
![]() |
![]() |