Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
I'm exporting huge of data to xml using (XMLAgg, XMLElement , XMLForest) in query.
In output file long lines are cut to 4003 chars.
It is sql developer limitations?
Solution I found:
Use Sql Developer 4.0.1. This version shows data in "query result" so, ctrl+A, ctrl+C and paste in notepad++/jedit. (standard Windows notepad may corrupt character set /UTF-8, CP...,)
This omits line length limit.