How to insert new line when generating xml from SQLPLUS

The Shadow

New Member
The XML generated by using \[code\]XMLAgg(XMLElement('student', ...)...)\[/code\]spits out everything onto one line. Given that I have a very large table, it reaches line length limit when spooling.I'd like to have each <student>...</student> node on a separate line. This page suggests using XMLText(x'0A') to insert new lines, but SQLPlus doesn't seem to recognize it.I've already tried :\[code\]set long 2000000000set linesize 32767set wrap onset trimspool on\[/code\]
 
Back
Top