Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Generic schema design
I mean that if you use a generic table where one column represents the
logical user table then all you need is where col01 =
user_logical_table_name [or ID] to find the logical user table rows and
since you are using a structure with multiple generic columns to hold
data you do not have to pivot multiple rows back into a single row for
use in the application.
But depending on how the data is to be accessed by the customer and presented you may not need to pivot the data anyway.
HTH -- Mark D Powell -- Received on Thu Feb 16 2006 - 13:02:50 CST