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

Oracle Apex JSON parsing with Nested Path

We face difficulties when we parsing nested path json content, in this post we will see how to parse using nested path with json content. before we see you need to know below names; JSON_TABLE NESTED PATH Refer this link :- Reference Oracle Document json content :- Below PL/SQL Code To Get Id from direct path and get user email from nested path Stored the … Continue reading Oracle Apex JSON parsing with Nested Path

Get Client IP Address from SQL PL/SQL

Hello All, This post explains how to get IP address from PL/SQL. “select owa_util.get_cgi_env(‘X-FORWARDED-FOR’) from dual;” ==================== O/P : 106.203.33.240, 23.205.118.109, 184.27.120.23 Function :- owa_util.get_cgi_env This function returns the value of the specified CGI environment variable. Although the WRB is not operated through CGI, many WRB cartridges, including the PL/SQL Gateway, can make use of CGI environment variables. Reference:- https://docs.oracle.com/cd/E28280_01/portal.1111/e12042/psutil.htm#YPREF417 Continue reading Get Client IP Address from SQL PL/SQL

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

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

Apex Views and Usage

apex_application_page_items To find / get detailed information about the page items and their properties  by using apex_application_page_items apex view. Example:  for example i need below column information item_name,  page_name, region, region_id, item_default SELECT item_name, page_name, region, region_id, item_default FROM apex_application_page_items WHERE application_id = 1127 AND item_name LIKE ‘%DEPARTMENT_NAME%’ AND item_source_type != ‘Database Column’ ORDER BY 2 Execute above query and get exact result. Continue reading Apex Views and Usage

Call Parent Page from Modal Dialog Dynamically

Call parent page from modal dialog dynamically, but how ? Method 1: Create one non-database item; for that item value, send the source page no from calling page. Then create one branch after page processing time, now page no should be your non-database item. Below for the reference Method 2: For every calling page have to create individual branch for send parameters to parent page. Continue reading Call Parent Page from Modal Dialog Dynamically

How to open Inline Modal Dialog in Oracle Apex

Inline modal dialog helps us more in critical situation such as through an error message to user, can execute DML process while through warning pop up message. In this post you can learn how to open inline modal dialog from simple java script code.

Step 1 : Create a inline modal dialog region.

 

Step1
Inline Modal Dialog Region

Also give static id for inline modal region ex:  “sampledialog” as below snap

Continue reading “How to open Inline Modal Dialog in Oracle Apex”

Interactive Grid simple dynamic action

Interactive grid most beautiful feature of Oracle Apex 5.1, it’s adapt with the form, as well reporting feature. So while creating the interactive grid we are facing the issue how to create dynamic action when column value changes. In this post we can see the step by step process creating a simple dynamic action for interactive grid.

Step 1: Create Interactive grid with this sample query

select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, ONLEAVE, NOTES, DEPTNO
from EBA_DEMO_IG_EMP

Continue reading “Interactive Grid simple dynamic action”