How to Hierarchical Query, Parents, Children and Their Cycles

This is a three-part Series How to Hierarchical Query, Parents, Children and Their Cycles How To Create Report in Oracle APEX based on Hierarchical Query How to use Hierarchical Query in Tree Plugin Part-1 How to Hierarchical Query, Parents, Children and Their Cycles Almost every one on this planet like trees right. Some of us like them as essential part of the world ecological system while others have created a very peculiar taste...

Read More

How To Treat The NULL Vacuum

It make some sense as the vacuum is something devoid of matter, something we do not really know about its contents, As does the NULL in a database. Here are a few points that need consideration as NULL plays the role of a double-edged sword in a database, providing a very efficient way to store unknown values , however not treated wisely could have a nastier effect especially, during data manipulation: The Term null value is inaccurate...

Read More

How To Install Coming Soon Packaged Sample Applications

How To Install Coming Soon Packaged Sample Applications Installing one of the Package Sample Application should be a piece of cake , right. While , I wonder why I find most often facing the situation where, when I try to install any of the Packaged Applications, It will throw Coming Soon into my face.😰 That's how a Computer would treat you nowadays, till you find your self in the abyss called troubleshooting mother lode of code and...

Read More

Oracle APEX Plugin KPI Numeric Cards, Dynamic

Apex 5 Universal theme, introduces many options to show information in the form of cards , badges. These components are mostly templates , and as Apex 5 comes with templates options, so does these templates. Although, some generic declarative option are there to style the information, to really customize the styling would need the use of custom javascript and css. Therefore, I tried to Introduce these KPI cards to display Numeric targets information...

Read More

Hard-coding vs. Soft-coding in PL/SQL and SQL

Thanksto Steven Feuerstein for his awesome work on pl/sql. This post is mostly summary and compilation with useful links at the end. All the files relating to hard-coding can be downloaded from here.🔗 Hard-coding Hard- coding, usually involves using Literal values, would be fine if nothing ever changed in our applications, only and only if: – Requirements, Tables' Definitions, Rules & Formulas and Configuration Constants ...

Read More

Oracle APEX Plugin Circliful Gauge , Fully Dynamic

The underlying concept is to show some kind of target /usage percentage with or without absolute values,Icon or Target Percentage. Example usage scenarios Departmental Performance/Cost percentages,  e.g. Dept A 30%, Dept B 70% Orders Completed by Department either absolute values or percentages Statistic like World Population by continent showing absolute values or proportions(percentages) The Features Fully Responsive Font awesome...

Read More

Oracle APEX dynamic Action Plugin Atom Calculator

Atom Calculator is a dynamic action plugin that allows users to perform calculations in real time during data entry by providing a popup calculator for the Input and get the final result. Donation Your support means a lot. Changelog 1.0 - Initial Release Install Import plugin file "dynamic_action_plugin_com_planetapex_atom_calculator.sql" from src  directory in the git Hub repository  into your application (Optional) Deploy...

Read More

How to use Font Awesome Animation Library in Applications

Since Oracle Apex (Apex ) already incorporates the amazing font awesome icons library . Its time to add some dazzle to those static icons. Font awesome already has a few animation parlor tricks up it's sleeves. However, I found that adding some of these extra animations wouldn't hurt. So lets dive in Get the Font Awesome Animation Library from download . Upload the minified CSS under the Shared Components =>  Static Application FilesCheck...

Read More