Re: Table and its view

It is a definite suspect!

But to be 100% sure that there exists a problem, TRY displaying the view definition.

==> SQL SCRIPT
set long 500 ;
select * from all_views where view_name = 'QUARTER_VIEW' ;

<== END SQL SCRIPT

If a WHERE CLAUSE exists in the view definition, it may explain the perceived discrepancies.

Hope this helps!

cheers :)
jeff

--
=============================================================================
Jeff Cerrafon
cerrafon_at_iconz.co.nz      "Hard work makes a good idea possible"
+64 25 955762
=============================================================================