Adding a blank line to CLOB
FormsMar 8 2009 — edited Mar 8 2009Hi gurus,
How can I add a blank line to a CLOB variable?
eg.
I have text <Batch> in a variable a (Varchar2). I have a string in variable b (CLOB).
When I use dbms_LOB.writeappend(v_clob,dbms_lob.getlength(a),a);
after that I populate b with values and finally do
dbms_LOB.append(v_clob,b);
Now I would like to add a blank line bw/ the contents of a and b while I do the append. How can I achieve it?
Thanks and Regards,
Forms.