SQL

How to handle data type conversion error in Oracle sQL

In earlier version we used exception handler or some other methods to get a values if incase facing conversion errors. From 12c onwards we are having very powerful feature “default null on conversion error“. From above code we will get ORA-01843: not a valid month error to avoid these kind of conversion issue we will use DEFAULT null ON CONVERSION ERROR. From above code we … Continue reading How to handle data type conversion error in Oracle sQL

apexthamaraiLeave a comment
Apex 19.2, apex 5.1

How to get lov display value in oracle apex

In old oracle apex version returns a display value from list of value item is bit complex but now we can easily get it from apex item interfaces. displayValueFor(pValue) is a interface method to get a display value of list of value item. In example we have Skill set LOV item, it listed out SQL, PL/SQL, Javascript and CSS. When user selects anyone of the … Continue reading How to get lov display value in oracle apex

apexthamaraiLeave a comment
Apex 19.2, Apex UI / UX, PL/SQL

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

apexthamaraiLeave a comment
web service

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

apexthamaraiLeave a comment
Apex 19.2, Apex 5.0, Apex Basics, PL/SQL, web service

Parse json data using APEX_JSON in Oracle PL SQL

How to parse JSON data in oracle apex ? Yes, We can parse json data with the help of apex_json and apex_json.t_values. User apex_web_service.make_rest_request Authorization method is Bearer Token Store the response in CLOB variable Parse the response json content with apex_json.t_values Count no of rows in json content Create for loop and get the object values using apex_json.get_varchar2 Insert / Update object value variables … Continue reading Parse json data using APEX_JSON in Oracle PL SQL

apexthamaraiLeave a comment
Apex UI / UX

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

apexthamarai2 Comments
Apex 19.2, Apex 5.0, apex 5.1

How to change modal dialog title dynamically in oracle apex

Question: How to change modal dialog title dynamically in oracle apex ? Answer:    Yes, It’s possible to change modal dialog title when page load. How: Using apex_util package Step1: Create dynamic action on page load Step2: Enter below code apex.util.getTopApex().jQuery(“.ui-dialog-content”).dialog(“option”, “title”, “Your title”); Step3: Run your dialog you can see dynamic title based on page item. Reference: See apex documentation Apex API Reference     Continue reading How to change modal dialog title dynamically in oracle apex

apexthamaraiLeave a comment
PL/SQL

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

apexthamaraiLeave a comment
Apex 19.2, Apex 5.0, apex 5.1, Apex Basics, Apex UI / UX

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

apexthamaraiLeave a comment
Jasper Report

Jasper Report Print when expression field is null or not null

Hello All, When we use jasper report design there will be a option to display a field by condition basis. Use field property “Print when Expression” option to show by condition basis. Show when field is null: new Boolean($F{FIELD_NAME} == null) Show when field is not null: new Boolean($F{FIELD_NAME} != null) Happy reporting with jasper! Continue reading Jasper Report Print when expression field is null or not null

apexthamaraiLeave a comment
Apex 19.2, apex 5.1, Apex Basics, Apex UI / UX, PL/SQL, SQL

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

apexthamaraiLeave a comment
Apex 19.2, Apex UI / UX

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

apexthamarai1 Comment