Oracle gods please help!

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

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:40:09 CST