I presume you mean in a Report? This can be done using a PL/SQL Column Headings function.
Open your report and select the Report Attrubutes tab.
Select the 'Headings Type' as PL/SQL.
You can then enter a PL/SQL Function that will query your table and return the required column headings.
Checkout Google.. It has a few links showing you how to do a crosstab report in pl/sql..
Okay, checked out the web examples and still having problems. I tried the DECODE(GROUPING(PERIOD_NAME4),1,'PERIOD_AMOUNT4',PERIOD_NAME4) AS PERIOD_NAME4, and the query returns PERIOD_NAME4 as the column header. It does have the amount in the column, so am closer. Here is my entire sql, any help is approciated.
decode(GROUPING (period_name4), 1, 'Period_Amount4', period_name4) as period_name4,
I was just trying to change the report to PL/SQL and cannot find the option that is in my book. When viewing the Report Attributes, the columns are listed but there is no options for Headings Type. I am on 4.1.0.00.32.
I also am still unable to get sql to work in TOAD to return the column value as the column header, any assistance is appreciated greatly.