Hi, I am facing a problem with the export data by SPOOL command.
I have a table with millions of rows, each row represents a group of information in XML format.
I created a script to record this data in an XML file.
In SQL * Plus, the generated file is compatible with my need, however, in sqlcl is not.
The problem is that it is always placed a CR + LF at the beginning of the file and after each record (or perhaps before each record).
This is my script:
And, this is te output:
In SQL * Plus first CR+LF is not inserted, so that the XML is valid.