Even if you need to operate on data that you don't have stored in your database, you still will be able to obtain necessary information from that data using solely Oracle Database tools, without having to retrieve and store the data first.
Consolidating data in access
XQuery query results can be then further processed in a parent SQL query or PL/SQL block, allowing greater flexibility for data transformation and consolidation.
It's important to realize that a non-Oracle Database data source you need to access is not always a source of non-relational data.
Thus, you might have to access data stored in another relational database system, such as SQL Server, Sybase, or DB2.
It has become the norm that enterprise-class databases can store different types of data natively.
Thus, for example, you might have CLOBs, BLOBs, and entire XML or HTML documents stored in your database, maybe even within the same table.
However, the ability of your database to provide native storage for non-relational data does not automatically mean it offers a toolset to efficiently operate on that content.
So, you still might need to employ external tools when it comes to manipulating data stored natively in your database.
OTN is all about helping you become familiar enough with Oracle technologies to make an informed decision.
Articles, software downloads, documentation, and more. Join up and get the technical resources you need to do your job.