Generate XML Through Table

1)  through Package

create table xxxml_t1(id number, str varchar2(10));

insert into xxxml_t1 values (1, 'AA');

insert into xxxml_t1 values (2, 'BB');



select dbms_xmlgen.getxmltype('select * from xxxml_t1')

from dual;

select dbms_xmlgen.getxmltype('select * from xxxml_t1 where id=1')

from dual;



2) through HTML Tags

SELECT aca.check_number,
      '<ROW>'||chr(13)||
      '<PAYMENT_NUMBER>'|| aca.check_number||'</PAYMENT_NUMBER>'||CHR(13)||
      '<Correlation_ID>'||  aia.ATTRIBUTE13 ||'</Correlation_ID>'||CHR(13)||
      '<Supplier_Number>'||  asa.segment1|| '</Supplier_Number>'||CHR(13)||
      '<Supplier_Name>'|| asa.vendor_name|| '</Supplier_Name>'||CHR(13)||
      '<Claim_Invoice_Number>'||  aia.invoice_num|| '</Claim_Invoice_Number>'||CHR(13)||
      '<Source_System>'||  aia.SOURCE ||'</Source_System>'||CHR(13)||
      '<Date_Of_Settlement>'||  aca.CLEARED_DATE|| '</Date_Of_Settlement>'||CHR(13)||
      '<supplier_id>'||  asa.VENDOR_ID|| '</supplier_id>'||CHR(13)||
      '<payment_amount>'||  aca.AMOUNT|| '</payment_amount>'||CHR(13)||
      '<CHECK_ID>'|| aca.CHECK_ID|| '</CHECK_ID>'||CHR(13)||
      '<payment_date>'|| aca.CHECK_DATE ||'</payment_date>'||CHR(13)||
      '<BANK_ACCOUNT_NAME>'||  aca.BANK_ACCOUNT_NAME|| '</BANK_ACCOUNT_NAME>'||CHR(13)||
      '<BANK_ACCOUNT_NUM>'||  aca.BANK_ACCOUNT_NUM|| '</BANK_ACCOUNT_NUM>'||CHR(13)||
      '<CURRENCY>'||  aca.CURRENCY_CODE|| '</CURRENCY>'||CHR(13)||
      '<claim_INVOICE_ID>'||  aia.INVOICE_ID|| '</claim_INVOICE_ID>'||CHR(13)||
      '<claim_amount>'||  aia.INVOICE_AMOUNT|| '</claim_amount>'||CHR(13)||
      '<claim_DESCRIPTION>'||  aia.DESCRIPTION ||'</claim_DESCRIPTION>'||CHR(13)||
      '<applied_AMOUNT>'||  aipa.AMOUNT|| '</applied_AMOUNT>'||CHR(13)||
      '</ROW>'  clob_clm
             FROM ap_checks_all aca,
                  ap_invoice_payments_all aipa,
                  ap_invoices_all aia,
                  ap_suppliers asa
            WHERE     aca.check_id = aipa.check_id
                  AND aipa.invoice_id = aia.invoice_id
                  AND aia.vendor_id = asa.vendor_id
                  and check_number=70145040
         ORDER BY aca.check_number;