Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how to retrieve fields & tables with name ending with YYYYMM

Re: how to retrieve fields & tables with name ending with YYYYMM

From: <pbolduc_at_my-deja.com>
Date: Fri, 17 Dec 1999 20:20:02 GMT
Message-ID: <83e5tc$8vb$1@nnrp1.deja.com>

 Dynamic SQL is your answer. Look into the DBMS_SQL package.

Phil Bolduc
North Vancouver BC Canada

In article <385770f5.0_at_news.cyberway.com.sg>,   "lai" <lyekheng_at_hotmail.com> wrote:
> Hi,
>
> I have fields and tables with name ending with YYYYMM, e.g.
> gross_amount_YYYYMM field, trfc_YYYY_YYYY table. If the current year
is
> 1999 and month is March, then the data would extract
gross_amount_199903
> field from trfc_1998_1999 table. Is there a way to do that?
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 14:20:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US