DSJ

Tag: PLSQL

  • Using Functions in Oracle SQL

    Using Functions in Oracle SQL

    Oracle subquery using WITH clause is a popular choice among the developers. From Oracle 12C it’s possible to define PLSQL function inside WITH clause. It’s a handy feature which is really useful when making complex queries

  • How to use DBMS_XMLDOM to create XML from PL SQL

    How to use DBMS_XMLDOM to create XML from PL SQL

    This example shows how to create an Oracle XML object using DBMS_XMLDOM package. It includes XML declaration (Version and Charset) XML namespace Looping through a cursor to add recursive nodes PART_CATALOG table consists of records in below structure Part_No Description UOM TEST1 test1 pcs TEST11 Test 1 pcs TEST111 111 VIAL Output XML looks like…