Inserting carriage returns in text field
Date: Mon, 19 Apr 1999 12:51:58 -0700
Message-ID: <7fg1kl$3ga_at_faile.nidlink.com>
[Quoted] hey all!
I'm back with another newby question that that "wonderful" oracle
documentation fails to address.
the problem is this: One large text field displays the concatenated results
[Quoted] of a query, but it all crunches together. I can add spaces or whatever
between entries, but what I would really like to do is add a carriage return
[Quoted] or better yet, a blank line, between entries.
This is what I am doing:
PROCEDURE GET_MESG IS today varchar2(300) :='';
CURSOR Today_mesg is
SELECT MESSAGE
FROM MAIN.CAL_INFO
WHERE MAIN.CAL_INFO.CAL_DATE = :INP_DATE
and MAIN.CAL_INFO.WHO_SEE = 2;
BEGIN
GO_ITEM('MESG');
CLEAR_ITEM;
for new in Today_mesg loop
today := today ||' *** '|| new.message;
end loop;
:MESG := today;
GO_ITEM(:GLOBAL.CUR_ITEM);
END;
Any help would be greatly appreciated. Please reply to wyma69_at_nidlink.com
thanx
Jim. Received on Mon Apr 19 1999 - 21:51:58 CEST