Print CLOB Column content in Oracle Apex Region

We all facing to print clob content in oracle apex report region. In this post we will see how to print clob content in “PL/SQL Dynamic Content Region”. Step 1: Create PL/SQL Dynamic Content Region. Step2: Make PL/SQL script to print in a region, for example see below script. Step 3: Use HTP.P to print HTML content. Refer below link Click to See Reference That’s … Continue reading Print CLOB Column content in Oracle Apex Region

Bootstrap Dynamic Tiles in Apex

How to make stylish bootstrap dynamic tiles in oracle apex ? Yes it’s possible to create a stylish bootstrap tiles in oracle apex. Bootstrap library (JS & CSS) files to be update in apex shared components “User Interfaces“. Create Static Content region in a page. Update required HTML content in Source text. Update required CSS and JS scripts in page inline css and global variable … Continue reading Bootstrap Dynamic Tiles in Apex

Oracle Apex interactive report fix column width

We can customize an interactive report column width as min or max pixels, let us see how its possible. Step 1:- Expand interactive report column properties, in that use HTML Expression as “<span class=”com-wrap”>#COMMENTS#</span>“ Step 2:- Expand page properties in that use Inline CSS Properties span.com-wrap { width: 100%; word-break: break-all; } “word-break” css will break the text content once reached overflow. We can customize an … Continue reading Oracle Apex interactive report fix column width

Print CLOB Content in Oracle Apex

How to show clob content in oracle apex page ? is it possible to show ? Yes, Possible to print clob content in oracle apex page with using of PL/SQL Dynamic Content Region. Step 1: Split CLOB content into small pieces of content with using of dbms_lob.read procedure. Example Code Snippet: DECLARE CURSOR crec IS SELECT html_message FROM mails_t WHERE email_id = 1001; rrec crec%rowtype; l_amt … Continue reading Print CLOB Content in Oracle Apex

Faceted Search – Shopping Cart Example

APEX 19.2 – Faceted Search – Is a important key feature in Oracle Apex 19.2 version, we can find the faceted region in a page or we can directly create a faceted page. – Create a faceted search page and search items. – Modify the Classic Report Template, to show the search results in different UI format. – Choose the Card template and modify the … Continue reading Faceted Search – Shopping Cart Example

Oracle Apex Customize CSS for Navigation Bar List

How to customize navigation bar list like background color font style? Yes, We can customize the navigation bar list items with User Defined Attributes Use 2nd Attribute to mention your CSS Classes. Mention your CSS Styles in your Global CSS or 0th page Style like below. .help_style .t-Button { font-weight: bold !important; background-color: red !important; } That’s it, now you can showcase your navigation bar list … Continue reading Oracle Apex Customize CSS for Navigation Bar List