Re: insert carriage return

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

insert into table a (textfield, intfield, longfield) values ('text', 99, 'some text folowed by followed by another
');

Just try it! Received on Sun Oct 21 2001 - 19:52:52 CDT