3 Replies Latest reply: Jul 22, 2014 8:16 AM by 405789 RSS

    Query result pane should show the entire XML as a result of the query execution

    405789

      Hi I am trying to get some xml output results returned in sqldeveloper returned in full.

      they are getting truncated.

      i tried the hint /*xml*/ but that is formatting the xml with cdata codes and  other pseudo structures.

       

        select xmlserialize(DOCUMENT

      XMLELEMENT("root",

      XMLAttributes('http://www.millicom.com' as "xmlns"),

      XMLAGG(

      XMLELEMENT("row",

      XMLFOREST(U.username,

                              U.user_id,

      U.PASSWORD,

      U.ACCOUNT_STATUS,

      U.LOCK_DATE,

      U.EXPIRY_DATE,

      U.DEFAULT_TABLESPACE,

      U.TEMPORARY_TABLESPACE,

      U.CREATED,

      U.PROFILE,

      U.INITIAL_RSRC_CONSUMER_GROUP,

      U.EXTERNAL_NAME,

      U.PASSWORD_VERSIONS,

      U.EDITIONS_ENABLED,

      U.AUTHENTICATION_TYPE))))

      AS CLOB INDENT)

        from dba_users U

      CROSS JOIN (select 1 from dual connect by level <=10);

       

       

       

      thanks for any help you can offer,.


      jm

       

        • 1. Re: Query result pane should show the entire XML as a result of the query execution
          Gary Graham-Oracle

          Hi jm,

          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 (11.2.0.3 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

           

          Regards,

          Gary

          SQL Developer Team

          • 2. Re: Query result pane should show the entire XML as a result of the query execution
            rp0428
            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 4.0.2.15.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?

            • 3. Re: Query result pane should show the entire XML as a result of the query execution
              405789

              Hi,

              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 4.0.2.15.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.

              jon

               

              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