Re: How do I insert a carriage return and a line feed into a column?

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 Spence