Using SQL XMLTable, XMLType, and XPath to Extract HTML CLOB Data

Introduction I recently had a colleague ask me for assistance on extracting particular pieces of data from an HTML CLOB stored in a database. The data represents some of the content from one of our wiki sites and he was trying to generate a report on some of that data. We considered using dbms_lob functions […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 4

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 3

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Creating a Mobile-Optimized REST API Using Oracle Service Bus – Part 2

Introduction To build functional and performant mobile apps, the back-end data services need to be optimized for mobile consumption. RESTful web services using JSON as payload format are widely considered as the best architectural choice for integration between mobile apps and back-end systems. At the same time, most existing enterprise back-end systems provide a SOAP-based […]

Improving XQuery performance

XQuery transformations are often used in pipelines in Oracle Service Bus to perform data transformation.  Performance of XQuery transformations is a key area to focus on when performance tuning an Oracle Service Bus environment. During performance testing of your project … Continue reading