Oracle SQL and PLSQL Beginner Resources
In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!! Oracle Dev Gym Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections: Classes: there are some really […]
BI Report in Oracle Cloud – The Basics
Today let us take a look at the basics on developing a new BI Report in Oracle Cloud. We will be creating a new custom report. Pre-Requisites for Developing the BI Report Before we start creating a bi report in Oracle Cloud, make sure you have access to Oracle Cloud Environment BI Developer Role You […]
XML Bursting in Oracle Apps
XML Bursting XML Bursting can be used to split one XML File into multiple XML Blocks. These individual xml blocks can then be used to generate reports and even use different layouts. You can also deliver the reports to multiple destinations based on a XML Element. The steps involved are listed below for your understanding: […]
Create XML Using SQL Statements
In this post we will take a look at how to create XML using SQL Statements. The following functions will be used to generate the output in XML Format. XMLElement () XMLForest () XMLSequence () XMLAgg () The combination of the above three functions will let us create some very fancy and complex XML Outputs. Lets […]
Create XML Using DBMS_XMLDOM
DBMS_XMLDOM The DBMS_XMLDOM package is used to access XMLType objects, and implements the Document Object Model (DOM), an application programming interface for HTML and XML documents. The Document Object Model (DOM) is an application programming interface (API) for HTML and XML documents. It defines the logical structure of documents, and the manner in which they are accessed […]