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 […]
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 […]
Password Protect PDF Output
In this post, we will explore how we can password protect PDF output generated by a Oracle XML Publisher Report. Check out my earlier posts on XML Publisher for more details on XML Data Template, RTF Template, Triggers etc. Now lets take a look at what we are planning to build today. You can download […]