Re: views on views on views

My blood boils too! Been there, done that.

One of the solutions that we implemented is to move the logic of the views in 
the database layer (views, PL/SQL, etc.) to the application layer (Java, C++, 
etc.).

It depends what your school of thought is. But I believe the database should 
store raw data. It should guarantee contstraint and referential integrity. 
That's it. Any data manipulation/calculation/display should be in the 
application layer.

--
Lyndon Tiu
--
http://www.freelists.org/webpage/oracle-l

Other related posts: