GLOBAL COVID'19 Tracker Powered by Oracle APEX 20.1

Link: https://apex.oracle.com/pls/apex/orclking/r/covid-19-tracker-global/home

Description: This application web based user friendly application to track global status for the corona virus outbreak.

Comments

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1: Go to page footer and copy and paste the below script. Page | <?fo:page-number?> of <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> : This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> : This is the syntax, which is used to represent the total number of pages. Step 2: Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Oracle Application Express Views (APEX)

Application Express Views Search SELECT * FROM apex_dictionary WHERE column_id = 0; View Comment Parent View APEX_APPLICATIONS Applications defined in the current workspace or database user. APEX_WORKSPACES APEX_APPLICATION_ALL_AUTH All authorization schemes for all components by Application APEX_APPLICATIONS ...

Save Selected Interactive Grid Records into a Collection - Oracle APEX

Here I am giving an example to save selected interactive grid records into a oracle apex collection. Step 1: Create a new blank page. Note: Mine was page 20. You will need to update reference to " P20 " with your page number if it's different. Step 2: Create a new interactive grid report region to the page using below query. Set Static Id "EmpDetails" to the region. SELECT * FROM ( SELECT emp . empno , emp . ename , emp . JOB , dept . dname department , dept . loc LOCATION , mgr . ename ...

About Oracle and Oracle ā'pěks (#orclapex)

Search This Blog