In the query result row, did you scroll all the way to the right, then double-click on the "..." at the end of the row to open the cell editor?
If that still does not show all the XML, it may be a problem with the version of the ojdb6.jar in use (220.127.116.11 client or higher is required), or whether or not the OCI/Thick JDBC is being used. Read through the following discussion: retrieve XMLTYPE based on registered schema very slow
SQL Developer Team
thanks for any help you can offer,.
We can't help if you don't show us what you are talking about.
Hi I am trying to get some xml output results returned in sqldeveloper returned in full.
they are getting truncated.
What does 'truncated' mean?
I run that query in Sql Dev 18.104.22.168.21 and it returns all results with each row duplicated 10 times just like you ask.
Why you want every row duplicated 10 times I don't know. What is the point of that?
thanks for feedback,
The purpose of duplicated the rows was to artificially increase the size of the XML for demonstration and testing purposes.
I have 22.214.171.124.21 of the ide, and
I did see the ellipsis after it was pointed out,
That is a workable solution, but it is a pity the tools of MS SQL Server are so much better than this SQL Developer,
I mean that if you run select * from table as XML auto in sql server ide you get a returned truncated row, that when you click on it
you get a fully formatted xml doc that opens in the editor.
Would be really nice to have such functionality in the sql developer rather than its dinky window dialog that opens.
thanks very much for all the answers.
as a follow up:
xml is native built in datatype in oracle db
why query output puts it output as a string?
we should get what is in the editor as default output.
indented, as oracle knows that it is a built in full datatype