Re: dynamic column name
Date: Mon, 26 May 2008 04:12:29 -0700 (PDT)
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-
> > 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