Re: dynamic column name

On May 25, 9:15 pm, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
> NOVA <nova1..._at_gmail.com> wrote in news:41c114f7-8676-453d-a9ac-
> 4326d6b59..._at_t54g2000hsg.googlegroups.com:
>
>
>
>
>
> > Dear all,
>
> > I have problem, the query as the following:
>
> > 1: SELECT
> > 2: CASE
> > 3:     WHEN PRODUCT_TYPE IN (SELECT PRODUCT_TYPE FROM PROD_T WHERE
> > TYPE_COL='ACCEPT_OS')
> > 4:     THEN (SELECT RESULT FROM PROD_T WHERE
> > PRODUCT_TYPE=OUTER.PRODUCT_TYPE)
> > 5:     ELSE 0
> > 6: END ACCEPT_OS
> > 7: FROM PRODUCTS_T OUTER
>
> > The problem in Line #5
> > The output from inner query is 'SRC' and it is single row.
> > The outer table 'PRODUCTS_T' has SRCcolumn.
>
> > I want specify thecolumnnamefrom inner query (line #5).
> > It islikedynamiccolumnname.
>
> > How can solve it?
>
> > Best Regards;
>
> EXECUTE IMMEDIATE
> -- but is scales about as well as a pig can fly.- Hide quoted text -
>
> - Show quoted text -

I try to use it, but not successful. Received on Mon May 26 2008 - 06:12:29 CDT