Re: column name as a part of the result set

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 16 Feb 2004 21:38:47 -0800
Message-ID: <1a75df45.0402162138.9475936@posting.google.com>

Daniel Morgan <damorgan_at_x.washington.edu> wrote
>
> Can not be done without hard coding.

You can use dynamic SQL and do a DESCRIBE on the cursor to fetch the column names/labels into a dynamic array... and then process it from there (i.e. iterate through column array per row for columns with the same name and then comparing the row's values to see if it is different or not).

I'm sure I've seen DESCRIBE supported in PL/SQL (it is an often used Pro*C/OCI function).

--
Billy

Received on Mon Feb 16 2004 - 23:38:47 CST