insert carriage return

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:01:46 CDT