How to Split CLOB column data into different rows - SQL PL SQL - Oracle

  SELECT DISTINCT

        PROJECT_NAME_ALIAS,

        USER_EMAIL,

        REGEXP_SUBSTR(MODULE_NAME, '[^:]+', 1, LEVEL) AS MODULE_NAME,

        LEVEL

    FROM 

        XXUSER_PROJECTS_MODULES

    WHERE 

       PROJECT_NAME_ALIAS like 'A%'

            CONNECT BY 

        REGEXP_SUBSTR(MODULE_NAME, '[^:]+', 1, LEVEL) IS NOT NULL

        AND PRIOR SYS_GUID() IS NOT NULL

        select * from XXUSER_PROJECTS_MODULES

        where project_name_alias like 'A%'

if modules are stored as below 

How to add page number in rtf templates in body - Oracle - Fusion

 If there is a requirement to add current page number and total page number in body of RTF template not in header and footer. Please check following.

For current page number, use <fo:page-number xdofo:report-page-number="true"/>

For total page number, use <?fo:page-number-citation:xdofo:lastpage-totalpg?>

How to start new section in RTF template in oracle fusion

Hi Team, 

If you have requirement where you want to display new page for each invoice then below section is for you. 

Happy Learning. 

<LIST_G_INVOICE>
   <G_INVOICE>
      <BILL_CUST_NAME>Vision, Incusive </BILL_CUST_NAME>
      <TRX_NUMBER>234568</TRX_NUMBER>
      ...
   </G_INVOICE>
   <G_INVOICE>
      <BILL_CUST_NAME>BCD </BILL_CUST_NAME>
      <TRX_NUMBER>234</TRX_NUMBER>
      ...
   </G_INVOICE>
   ...
</LIST_G_INVOICE>
...

Each G_INVOICE element contains an invoice for a potentially different customer. To instruct BI Publisher to start a new section for each occurrence of the G_INVOICE element, add the @section command to the opening for-each statement for the group, using the following syntax:

<?for-each@section:group name?>

where group_name is the name of the element for which you want to begin a new section.

For example, the for-each grouping statement for this example is as follows:

<?for-each@section:G_INVOICE?>

The closing <?end for-each?> tag is not changed.

The following figure shows a sample template for batch reports:

Note:

The G_INVOICE group for-each declaration is still within the body of the report, even though the headers are reset by the command.

The following table describes the values of the form fields from the template in the previous figure (that shows a sample template for batch reports):

Default Text Entry	Form Field Help Text	Description
for-each G_INVOICE	<?for-each@section:G_INVOICE?>	Begins the G_INVOICE group, and defines the element as a Section. For each occurrence of G_INVOICE, a new section is started.