Re: retrieving only the column label

Hi,

select col1 as NAME, col1 as ",", col2 as EMAIL from TABLE where rownum < 1;

• Kenneth Koenraadt plovmand@<no-spam>hotmail.com

On Sun, 11 Mar 2001 01:49:21 +0900, "Lee, Seung K." <vrman_at_sl2sys.co.kr> wrote:

>Good day group...
>
>here's my problem
>
>All I want the query to return is just the column label,
>preferably with a delimiter I can assign.
>
>Let me elaborate.
>I have
>
>select col1 as NAME, col2 as EMAIL from TABLE;
>
>it would give
>
>NAME EMAIL
>---------------------------------
>Leee Lee_at_somewhere.com
>........
>........
>
>I just want "NAME and EMAIL". Straight forwardly anything after AS.
>If possible with a delimeter ,(comma)
>which would give name,email. Don't need the query result.
>
>I need this because we're working with various databases and
>they have different column name for obviously same content
>and we want to unify it.
>We're doing this with a c program. I guess I can string compare
>the query sentence and pick out the aliases
>but I thought there must be a better way...
>
>Well~ if this is a one of those question that always comes up...
>My apologies but I've really gone though the doc's I've got.
>TIA
>
>
>
>
>
Received on Sat Mar 10 2001 - 12:00:13 CST