Generating XML with Namespace information

View All Scripts Login to Run Script

Script Name Generating XML with Namespace information
Description Generating simple XML content with Namespace information in it. Be aware that browsers will always generate pretty printed output and hiding the XML instance properties like version.
Area SQL General / XML
Contributor Marco Gralike
Created Thursday October 29, 2015

Statement 1

SELECT xmlelement("TADIGEID"    
                 , xmlattributes    
                    (  'https://infocentre.gsm.org/TADIG-EID' as "xmlns",    
                       'https://infocentre.gsm.org/TADIG-GEN' as "xmlns:tadig-gen",    
                       'http://www.w3.org/2001/XMLSchema-instance' as "xmlns:xsi",    
                       'https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd' as "xsi:schemaLocation"    
                    )    
                 , xmlelement ("ObjectType", object_type  )    
                 , xmlelement ("Info", xmlattributes (object_id as "Id"))    
                )  AS namespace_example    
  FROM ALL_OBJECTS    
 WHERE ROWNUM <= 2

 
NAMESPACE_EXAMPLE
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"><ObjectType>EDITION</ObjectType><Info Id="133"></Info></TADIGEID>
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"><ObjectType>TABLE</ObjectType><Info Id="142"></Info></TADIGEID>

2 rows selected.

NAMESPACE_EXAMPLE
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"><ObjectType>EDITION</ObjectType><Info Id="133"></Info></TADIGEID>
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"><ObjectType>TABLE</ObjectType><Info Id="142"></Info></TADIGEID>

Statement 2

SELECT XMLSERIALIZE (CONTENT ( xmlelement("TADIGEID"     
                                         , xmlattributes     
                                            (  'https://infocentre.gsm.org/TADIG-EID' as "xmlns",     
                                               'https://infocentre.gsm.org/TADIG-GEN' as "xmlns:tadig-gen",     
                                               'http://www.w3.org/2001/XMLSchema-instance' as "xmlns:xsi",     
                                               'https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd' as "xsi:schemaLocation"     
                                            )     
                                         , xmlelement ("ObjectType", object_type  )     
                                         , xmlelement ("Info", xmlattributes (object_id as "Id"))     
                                        )       
                             ) AS CLOB indent SIZE=0     
                    ) AS not_pretty_print     
  FROM ALL_OBJECTS     
 WHERE ROWNUM <= 2

 
NOT_PRETTY_PRINT
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd">
<ObjectType>EDITION</ObjectType>
<Info Id="133"/>
</TADIGEID>
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd">
<ObjectType>TABLE</ObjectType>
<Info Id="142"/>
</TADIGEID>


2 rows selected.

NOT_PRETTY_PRINT
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"> <ObjectType>EDITION</ObjectType> <Info Id="133"/> </TADIGEID>
<TADIGEID xmlns="https://infocentre.gsm.org/TADIG-EID" xmlns:tadig-gen="https://infocentre.gsm.org/TADIG-GEN" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://infocentre.gsm.org/TADIG-EID tadig-eid-10.0.xsd"> <ObjectType>TABLE</ObjectType> <Info Id="142"/> </TADIGEID>

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database