Need to get the output of a column with its column name in as rows

Hi Have the following table columns curvedetails_id, curve_id, curvedetails_date, p0030, p0100, p0130, p0200, p0230, p0300, p0330, I need to do a query that does the following output CurveId" ,"CurveDate", "PNumber", "PReading" "206116", "31-Dec-2002", "P0030", "26.

RE: Need to get the output of a column with its column name in as rows

One way to do this is to write an PL/SQL block and use utl_file package Guang -Original Message- [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:21 AM To: Multiple recipients of list ORACLE-L rows Hi Have the following table columns curvedetails_id, curve_id, curvedetails_date, p0030