BI Publisher

SELECT xt_list.*, xdo_db.*
    FROM (SELECT XDDV.data_source_code "Data Definition Code",
                 XDDV.data_source_name "Data Definition",
                 XDDV.description      "Data Definit...

SELECT XDDV.data_source_code   "Data Definition Code",
       XDDV.data_source_name   "Data Definition",
       XDDV.description        "Data Definition Description",
       XTB.template_code       "T...

SET SERVEROUTPUT ON

DECLARE
   -- Change the following two parameters
   var_templatecode    VARCHAR2 (100) := 'XXTEST';            -- Template Code
   boo_deletedatadef   BOOLEAN := FALSE;
   -- del...