Re: views on views on views
Date: Thu, 26 Mar 2009 08:36:27 -0700
('binary' encoding is not supported, stored as-is)
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.
http://www.freelists.org/webpage/oracle-l Received on Thu Mar 26 2009 - 10:36:27 CDT