XML

XMLTABLE to convert XML to relational data

XMLTABLE: Convert XML Data to Relational Form

Using the SQL/XML function XMLTABLE in Oracle database 12c, to map XML data into relational rows and columns.

Read the Full Article →
Oracle XML Object-Relational Storage

Oracle XML Object-Relational Storage [EXAMPLE]

Object-relational storage of XML data in Oracle is based on shredding the XML data into SQL objects. Scripts and stepwise execution for object-relational XML storage.

Read the Full Article →
Thumbnail image for Oracle Binary XML Storage, With or Without XML Schema [EXAMPLE]

Oracle Binary XML Storage, With or Without XML Schema [EXAMPLE]

Working examples of Oracle binary XML storage, with or without XSD, along with steps needed to configure and register the XSD in Oracle.

Read the Full Article →
Thumbnail image for Storing XML Data in Oracle: Binary XML, Object-Relational, CLOB

Storing XML Data in Oracle: Binary XML, Object-Relational, CLOB

Binary XML, object-relational, or CLOB? An overview of approaches for storing XML data in Oracle to best fit the nature of the data and its expected use.

Read the Full Article →
SQL XML in Oracle: Generating XML from Relational Data

Generating XML from Relational Data using Oracle SQL/XML

How to generate XML from relational data using a combination of Oracle SQL/XML functions such as XMLELEMENT, XMLATTRIBUTES, XMLFOREST, XMLAGG, XMLSERIALIZE.

Read the Full Article →
Thumbnail image for Access Control List (ACL) in Oracle 11G

Access Control List (ACL) in Oracle 11G

Access Control List or ACL is a security mechanism that defines which users or roles can perform which operations on which data. It is an essential setup in Oracle 11G for running network packages such as UTL_HTTP.

Read the Full Article →
Thumbnail image for UTL_HTTP to Call a Web Service from PL/SQL

UTL_HTTP to Call a Web Service from PL/SQL

You can call a web service from PL/SQL using the Oracle-supplied package UTL_HTTP. This article demos a PL/SQL script to invoke a web service and read its response into a CLOB. It also describes typical errors you may encounter in web service calls and how to resolve them.

Read the Full Article →
Thumbnail image for Referencing User Defined Types over DBLink: Problem and Alternatives

Referencing User Defined Types over DBLink: Problem and Alternatives

Understanding PLS-00453, the error that shows up when a UDT is used as a procedure parameter across DBLink, Plus a few ways to work around it.

Read the Full Article →
PIVOT in Oracle to Select Rows As Columns

PIVOT in Oracle 11G to Select Rows As Columns

A frequent requirement in SQL is to "pivot" a result set – that is, display rows as columns. Before 11G, the developer had to do the equivalent of jumping through hoops to pivot the data. In 11G, with the introduction of the new PIVOT syntax, the task of transposing rows to columns has become a […]

Read the Full Article →