Blog 3 column All Masonry

APEX

When building a Progressive Web Application (PWA) in Oracle Application Express (APEX), there are several orientation settings that you can configure to control how the...

Office 365 Email Integration using Oracle APEX REST Data Source & Synchronization – Zero (Code) Integration

APEX, Integration, Oracle

A blog after many years, thanks to @Jaydip Bosamiya for encouraging me to resume blogging. Recently one of our client wanted to implement Office 365...

VacciSafe – Internship Project

Internship

I am Dev Anuj Patel, Std. 12th student (2022-23), who got this golden opportunity of an internship project with ZeroIntegration.com. After a good amount of...

Oracle APEX region plugin – GeoChart

APEX, JavaScript, jQuery, Oracle, SQL

GeoChart region plugin can be used to visualize data on a google map. You can analyze and display geographic data and present it on the...

Oracle APEX item plugin – Address Picker

APEX, JavaScript, jQuery, Oracle, SQL

Why we need?It is difficult for end user to enter exact location of the address, so we have developed plugin which allows end user to...

Oracle APEX – Build Your Own Enhanced Nested Report

APEX, Oracle

With lots of feedback and suggestions – which inspired me to dig further into Customized Nested Report and see how we can enhance this further....

Oracle APEX – Interactive Report – Scrollbars on Top

APEX, Oracle

I have been came across an interested requirement ( which is very valid ) to add scrollbars on the top of the regions! I have...

Oracle APEX Universal Theme – Floating Action Button with List Template

APEX, Oracle

In continuation to my previous blog post about adding simple floating button. This blog is about how you can create a list template that will...

APEX, Oracle

Inspired from Material APEX theme to have Floating button in my application. But, I also do not want to migrate from Universal Theme. So, following...

APEX_JSON – How to build Nested JSON

APEX, Oracle

I have been came across requirement for printing nested JSON in one of the application. Using APEX_JSON, there is no straight forward way – I...

APEX, Oracle

Oracle APEX Interactive Report (IR) has rich APIs to tweak, customize or control the user interactions. One of the API package I have recently used...

Oracle APEX – Warn unsaved changes for custom fields

APEX, JavaScript, jQuery, Oracle

Oracle APEX 5 introduced a new feature called “Warn on Unsaved Changes” at page, item and button level. This is a great feature by enabling...

Oracle APEX Tabs Container – Control selection using jQuery

APEX, jQuery

This blog is about how you can control the tab selection using jQuery for Tabs Container region. I have seen, there are many other-ways to...

APEX, Oracle

APEX Office Print (AOP) is a great document printing library for Oracle APEX. While using AOP to print IR or Chart regions into document, you...

Oracle JET Charts – Series Bar Chart with Zero Value Bars

APEX, Oracle

Oracle JET Charts is a beautiful chart library which has out-of-box support in Oracle APEX version 5 on-wards. Purpose of this blog is to introduce with...

Oracle SQL Developer – Connection bar is not opening

Oracle, SQL

I came across a very strange issue with my SQL Developer. The connection bar is not opening/expanding/minimizing/maximizing. So, I was scared thinking that I have...

jQuery Circular Progress Bar – Pie Chart

APEX, jQuery, Oracle

I have came across following URL – which shows how simply you can create jQuery Circular Progress Bar. https://webdevtrick.com/circular-progress-bar-css/ Based on provided information on above...

APEX, Oracle

With new release of Oracle APEX, we have choice of using either Font APEX or Font Awesome. I really like both the option, but what...

APEX, Oracle

Apex Office Print (AOP) is a great tool for document printing, document conversion and document merging. We have used AOP Converter API to merge pdf...

Create RESTful web service to download BLOB content

APEX, Oracle

I have been using RESTful API to download BLOB content as a file. This is very useful in many places where you want to give...

Close wait popup on validation trigger

APEX, jQuery

Today, I came across a scenario when, there was a validation on my page and I have SUBMIT button which will do validations. I also...

APEX, Oracle

With apex 5 on-wards, we have Dialog Closed event in dynamic action. This can be used in many places such as, you want to refresh...

APEX

Here is something new and interesting work-around I found out while working on validating apex authorization scheme using my custom pl/sql function. So, initially I...

APEX

With apex 18 Universal theme, we have got few Card templates. It re-presents the information in Card format. Click here to see few examples of...

APEX

Many times your APEX Work-space accounts gets locked on few wrong attempts or any other reasons – This normally requires you to contact administrator and...

APEX

When your images are uploaded into WORKSPACE_IMAGES and you want to use that into AOP template, following can be a simple way to do it....

APEX

Apex Office Print is one of the popular tool for generating documents using Oracle APEX. While using AOP process type plugin, you will commonly see...

APEX, jQuery

We are using JSON as data format with RESTful services quite a lot in Oracle APEX. But, purpose of this blog is to see how...

APEX, jQuery

Here is how you can create cool nested reports in Oracle APEX and jQuery, which looks like below: For this example, I have used DEPT...

APEX

WooCommerce is one of the popular WordPress plugin and is widely used as a eCommerce platform. WooCommerce has provided REST web services to pull and...

APEX, Oracle

How to use global page (page 0) region positions to show them in Wizard Modal Dialog Header and Footer location in Universal Theme? Step 1:...

PL/SQL Best Practices

APEX

A blog after many years 🙂 My best practices for PL/SQL are below: Always use Exception Block within each block, function, procedure Send email to...

ALL, ANY and SOME Comparison Conditions

SQL

It is quite possible you could work with Oracle databases for many years and never come across the ALL, ANY and SOME comparison conditions in...

Lag Lead Analytic Functions

SQL

Hi friends, How to calculate difference between columns of current and previous/next row? Let’s say, you want to monitor how often products are sold from...

Show All APEX Integration Internship JavaScript jQuery Oracle SQL

Categories

Contact Us

Blogs

Oracle APEX – Interactive Report &

How to create your own customized nested