Re: How do I insert a carriage return and a line feed into a column?
From: Kevin Michael Vail <kevin_at_vailstar.com>
Date: 1997/08/31
Message-ID: <kevin-3108972210040001_at_200.200.200.202>#1/1
Date: 1997/08/31
Message-ID: <kevin-3108972210040001_at_200.200.200.202>#1/1
In article <5u7ij8$16f2_at_nntp6.u.washington.edu>, lesliet_at_u.washington.edu (L. Tseng) wrote:
>Hi,
>
>I was wondering how a carriage return and a line feed
>can be inserted into a varchar2(255) column so
>the text will be in certein format when retrieved.
Insert into the_table values ('blah blah blah ' || CHR(13) || CHR(10) || '...');
-- Kevin Michael Vail | I would rather have a mind opened by wonder kevin_at_vailstar.com | than one closed by belief. -- Gerry SpenceReceived on Sun Aug 31 1997 - 00:00:00 CEST