Re: column name as a part of the result set

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 12 Feb 2004 20:24:55 GMT
Message-ID: <402BE117.ABDE371F@remove_spam.peasland.com>

> Is it possible to get the column name as a part of the result in a
> query without using PL/SQL? I can use a procedure if necessary.

How do you propose to use a stored procedure, but not use PL/SQL?????

It seems to me that you already know the column name. After all, you already have the following in your sample SQL statement:

> Select
> at.ID_COL,
> at.VAL_COL,
> column_name (this is what I need)

So why not turn this into:

Select

        at.ID_COL,
        at.VAL_COL,
        "VAL_COL" as column_name

etc.

Does that work?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Thu Feb 12 2004 - 14:24:55 CST