Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can I insert <CR><LF> in VARCHAR?
Just use function CHR, for example
INSERT INTO T1 VALUES ('Dave'||CHR(10)||'Nels');
Dave Nels пишет в сообщении ...
>Hello,
> I have an C external procedure that expects as a parameter a string
that
>represents the body of an email message. My problem is I can not figure out
>how to insert a binary carriage-return, line-feed pair into a string
literal
>that is the corresponding VARCHAR parameter in my PL/SQL function that is
>the proxy for this external procedure. Can this be done
>
>Thanks,
>Dave Nels
>
>
Received on Thu Jan 21 1999 - 17:11:14 CST