OraQA

Oracle Question and Answer


Latest Comments

  • Laurent Schneider:
    if you like a Base64 format, maybe this… select utl_raw.cast_to_varchar 2(...

  • hsafra:
    You need to give more specs for the question: What letter are acceptable? What letters aren’t? Do you...

  • ragunathansd:
    I am not inserting sequence numbers from database. I need to populate the data in a grid. If a user...

  • gamyers:
    “redo log file gets full” That is the nature of a redo log file. It gets full, switched and...

Comments RSS feed


  • Do you have a solution to a problem? Do you have an unanswered question? Login and share it with the Oracle community. More...

Oracle News


Entries RSS feed

Comments RSS feed
« How do I write this query?

Where to get Oracle? »

How to Generate XML Data from the Database

April 27th, 2006 By Eddie Awad

You can generate XML from the database using:

  • Standard SQL/XML Functions:
    • XMLELEMENT
    • XMLATTRIBUTES
    • XMLFOREST
    • XMLCONCAT
    • XMLAGG
    • XMLPI
    • XMLCOMMENT
    • XMLROOT
    • XMLSERIALIZE
    • XMLPARSE
  • Oracle Database SQL Functions:
    • XMLSEQUENCE
    • XMLCOLATTVAL
    • XMLCDATA
    • SYS_XMLGEN
    • SYS_XMLAGG
  • DBMS_XMLGEN
  • XSQL Pages Publishing Framework
  • XML SQL Utility (XSU)
  • DBURIType

Some of the options above may not be available in versions of the Oracle database earlier than 10g Release 2 (10.2).

For more details on each of the above options check out:

Related links:

If you have any additional XML resources, please add them in the comments below.

Filed under PL/SQL, SQL, XML. Follow any responses to this entry through this RSS 2.0 feed.  

Leave a Reply

You must be logged in to post a comment.

RSS feed for comments on this question
« How do I write this query?

Where to get Oracle? »