Re: Table and its view

In article <D1vEy3.7I4_at_mail.auburn.edu> you wrote:  

: 1) If quarter_view is a view of quarter, then it should show the same number of rows always.
 

No, that's not so. If the view has a condition in its select statement, then it may show fewer number of rows.  

: 2) If quarter_view is NOT a view of the quarter, it should not increase the count in quarter automatically.
 

Yes, that's true.  

: Please let me know what could be the problem.
: THANKS IN ADVANCE.
  I think quarter_view is a view. If you look into table sys.dba_objects, and seeks for a object_name = quarter_view. You should find out what kind of object it is, by looking at parameter object_type. You can also look at table sys.dba_views to take a full overview of the view. But before you do the select, you must run this in sqlplus:

        set long n
Where n = no. of characters you want to display. It depends on the size of the view, but someplace between 200-1000 should be enough.  

Hope this helps.  

Morten Kristiansen (d93krist_at_hfk.mil.no)   Received on Wed Jan 11 1995 - 13:04:21 CET