Re: retrieving only the column label

This isn't the answer you were asking for but...I wouldn't do this in SQL. I'd do it in PL/SQL where I could watch what was going on and write error messages if I got columns that were different from what I expected etc.

Van

"Lee, Seung K." <vrman_at_sl2sys.co.kr> wrote in message news:98dlff$7s7$1_at_news2-2.kornet.net...
> 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 - 18:26:49 CST