Use of CASE Statements in PL/SQL. Oracle9i XML Generation Using DBMS_XMLQuery, DBMS_XMLGen, Sys_XM. Oracle9i has a number of XML generation mechanism with the most flexible being the XML SQL Utility (XSU).
The XSU was introduced in Oracle 8i as a Java Servlet. In Oracle 9i its functionality has been extended, with a subset of it's functionality being incorporated into the database kernel giving improved performance along with Java and PL/SQL APIs. In this article I shall discuss DBMS_XMLQUERY PL/SQL interface to XSU, the DBMS_XMLGEN package and the SYS_XMLGEN and SYS_XMLAGG functions. Related articles. Basic XML Generation. Oracle9i CASE Expressions And Statements. The CASE expression was first added to SQL in Oracle8i.
Oracle9i extends its support to PL/SQL to allow CASE to be used as an expression or statement. Value Match CASE Expression The CASE expression is a more flexible version of the DECODE function.