Table and its view
Date: Wed, 4 Jan 1995 07:46:50 GMT
Message-ID: <D1vEy3.7I4_at_mail.auburn.edu>
Hello Everyone,
I have a table named "quarter". I also have another table named "quarter_view". When I describe them,
SQL> desc quarter;
both of them are showing the same attributes (I mean columns). These two tables were created by my predecessor and I am doing that job now. Initially, I thought quarter is the table and quarter_view is view of quarter. But, they are not showing the same number of records. But, when I add a record into quarter_view, the count is automatically increasing in quarter also. Please see the following for an example.
Initially, I did this.
SQL> select count(*) from quarter_view;
COUNT(*)
2835
SQL> select count(*) from quarter;
COUNT(*)
3972
After adding a record in quarter_view, both rows in quarter_view and quarter are increased by one as shown below:
SQL> select count(*) from quarter_view;
COUNT(*)
2836 -- initially it was 2835
SQL> select count(*) from quarter;
COUNT(*)
3973 -- initially it was 3972
SQL> desc quarter_view;
Please let me know what could be the problem.
THANKS IN ADVANCE.
Moorthy
(moorthy_at_eng.auburn.edu)
--- :=) Do unto others as you would wish to be done by others. :=)Received on Wed Jan 04 1995 - 08:46:50 CET