Re: insert carriage return

INSERT INTO A (textfield, intfield, longfield) VALUES('text', 99, 'some text' || CHR(13) || CHR(10) || 'more text' || CHR(13) || CHR(10)); Brian

On Fri, 19 Oct 2001 18:01:46 GMT, ttigger4321_at_hotmail.com (tony) wrote:

>I want to insert carriage returns into a field of datatype long. For
>example in sqlplus.
>
>insert into table a (textfield, intfield, longfield)
>values ('text', 99, 'some text folowed by carriage return followed by
>more text followed by another carriage return');
>
>Des anybody know how to do this?
>
>thanks
>cheers,
>tony
>494-1021 w
>461-4550 h
Received on Fri Oct 19 2001 - 13:30:48 CDT