Re: SQL Syntax
One problem with EAV is that it forces you to write a pivot table query for even the simplest retrieval. Arguably, it's unprofessional to implement such a design unless you can prove there's no alternative, and I notice you don't provide that reason. So I'll just refer you to "Pivot table basics: rows vs. columns" at
http://www.artfulsoftware.com/queries.php, which outlines the basics of EAV query logic.
PB
http://www.artfulsoftware.com
Subject
Written By
Posted
November 23, 2009 03:51AM
November 23, 2009 08:51AM
November 23, 2009 10:44PM
November 24, 2009 12:18AM
Re: SQL Syntax
November 24, 2009 11:18AM
November 24, 2009 12:12AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.