Since you didn't specify, I will assume you mean in Oracle 10g. There are a lot of ways to see XML using SQL. By...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
"see", I am also assuming that you mean create XML from relational data.
For selecting data using only SQL, there are the SQLX functions, XMLElement, XMLAGG, XMLattribute, etc. If you are using PL/SQL, in addition to SQLX, you can use DBMS_XMLQquery and to present XML on the Web you can use XSQL.
Without a more specific question, I think examples would be pointless. A great place to start would be Oracle's documentation Web site. The benfit of this site is well worth the time it takes for a free registration. You can search the documentation for XML, EMLElement, XMLType, XML DB,XDK and XMLQuery. Any of those will get you started. If you have a more specific question, please post it.
Dig Deeper on Oracle XML
Related Q&A from Lewis Cunningham
How can I tell if a column is a NUMBER or VARCHAR in PL/SQL? Is there a function to do this?continue reading
I need to somehow log the execution time for two procedures every time they are called and save that data (in a table?). Do you know of a way to ...continue reading
I need a step-by-step procedure for importing text to an Oracle database using a stored procedure.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.