Microsoft database and ad-hoc query tools provide a cross-tabulation
query which effectively denormalizes selected data - for example, by
attaching table DBA_SEGMENTS to a Microsoft Access database, it is
possible to define a cross-tab query which shows segment types in rows
and tablespaces in columns, where the intersection displays the number
of segments of each particular type in each tablespace.
Is there any Oracle SQL query which can emulate this capability? The
query should not assume anything about the particular types of objects
and tablespaces in the database.
Received on Sun Sep 19 1999 - 23:55:58 CDT
