Re: Transform Columns to Rows (Unusual)

I know you wanted a view but because of the complex nature of what you wanted to do, you may never be able to produce a view using standard SQL. If you wanted the data for reporting, why not use the PL/SQL given in a pre-report trigger of some sort to create a temporary table and then report on that? Have used that technique a lot in the past.

M

dbergquist_at_bd.com (David Berg) wrote in message news:<1274998b.0302060841.31e9bb0_at_posting.google.com>...
> Looks good for inserting records in a new table. The variation of this
> that i actually need is a view or procedure to dynamically transform
> the data from the original table for use in a Report.
Received on Fri Feb 07 2003 - 09:57:05 CET