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: Oracle gods please help!

Re: Oracle gods please help!

From: Moore <rlmoore_at_purdue.edu>
Date: Mon, 13 Mar 2000 15:58:45 -0500
Message-ID: <Pine.SOL.4.10.10003131557270.13090-100000@herald.cc.purdue.edu>


Oops found it:

g_instring(25) !

On Mon, 13 Mar 2000, Moore wrote:

>
> I am attempting to write a function that will return something like
>
> ('01-00', '02-00', '03-00')
>
> However I am having quite a bit of trouble.
>
> Here is my attempt:
>
> CREATE OR REPLACE
> FUNCTION get_Past3Months RETURN CHAR IS
> g_InString CHAR(19);
> c_MY1 CHAR(5);
> c_MY2 CHAR(5);
> c_MY3 CHAR(5);
> BEGIN
>
> SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'MM-YY')
> INTO c_MY1
> FROM dual;
>
> SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -2), 'MM-YY')
> INTO c_MY2
> FROM dual;
>
> SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -3), 'MM-YY')
> INTO c_MY3
> FROM dual;
>
> g_InString := '(' || '''' || c_MY1 || '''' || ',' || '''' || c_MY2
> || '''' || ',' || '''' || c_MY3 || '''' || ')';
>
> Return(g_InString);
>
> END;
>
> HELP
>
> TIA
>
>
>
Received on Mon Mar 13 2000 - 14:58:45 CST

Original text of this message

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