Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using dbms_lob append to insert text how do you insert a new line inbetween

524221May 7 2009 — edited May 7 2009
DBMS_LOB.APPEND (P_TEXT,'* Operator Phone,');
---- inbetween I need to insert new I am using DBMS_LOB.APPEND (P_TEXT,CHR(10)); IS there amy better method?
DBMS_LOB.APPEND (P_TEXT,'* Operator Email Address,');
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2009
Added on May 7 2009
4 comments
3,103 views