Posts

Tool-tip with Image in Oracle APEX Report

Image
I have built this  tool-tip with image feature  for one of my customer and they were very happy about it, So here I am giving an elegant way for adding tool-tip with image in Oracle APEX Report  using Jquery. Tool-tip:  The tool-tip, also known as info tip or hint , is a common graphical user interface element in which, when hovering over a screen element or component, a text box displays information about that element (such as a description of a button's function, or what an abbreviation stands for). The tool tip is displayed continuously as long as the user hovers over the element. Step 1:  Create table and populate some sample records. CREATE   TABLE  fxgn_documents  ( document_id  NUMBER   PRIMARY   KEY ,                                sequence_no  NUMBER ,                                file_name    VARCHAR2 ( 240 ),                              file_url     VARCHAR2 ( 4000 ),                              updated_by  VARCHAR2 ( 240 ),                                updated_on 

Awarded Member of the Month (June) by Oracle APEX Community

Image
  I would like to share this achievement with you all that, I was awarded "Member of the Month" by Oracle APEX Community at apex.world  for my Plug-Ins (6 Nos) in June 2021. Perfection lies in doing ordinary things extraordinarily well, Perseverance and Perfection has led me to this Oracle Apex Community Award as Member of the month , would like to dedicate this award to  Joel Kallman , without whom we would not have this community nor these awards. The Plug Ins are; 1) APEX Google Pie Chart 2) Number Field with Decimal   3) Heat Map Report 4) Heat Map Chart 5) Tag Cloud Chart 6) Slideshow Tweet by orclapexworld: An award is a morale booster, An award gives you that high no drug in this world can give, today I am totally on a new high, and I was on Cloud, but moments I realized that there is a lot more to achieve, because, The day I get satisfied by myself, there ends my learning, with this my learning should become more intense and more concentrated, Thanks everyone who h

Plug In: Image Magnifier Glass

Image
A plug in to enlarge a image using lens or mirror (glass). Credits goes to w3schools . Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "item_type_plugin_orclking_image_magnifier_glass.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export plugin file  "item_type_plugin_orclking_image_magnifier_glass.sql"   from  GitHub  source directory and import it into your application. Navigation: Shared Components ==> Plug-ins ==> Import Plugin will be listed under plug-ins bucket after successful installation. Step 2: Create a new blank page. Step 3: Create a new region to the page. Step 4: Create a item to the region and change the item type to Image Magnifier Glass [Plug-In] . Note: You can define image URL u

My technical blog is listed in Top 100 Oracle Blogs And Websites To Follow in 2021

Image
  I am happy to announce that, my technical blog About Oracle and Oracle ā'pěks (#orclapex) has been selected by Feedspot panelist as one of the top 100 Oracle Blogs and Websites for Oracle APEX Developers to follow in 2021.  Rank# 30 Thanks to Feedspot  and Anuj Agarwal for getting this listed. Happy Coding.

Plug In: Bootstrap Carousel Extension

Image
A carousel/slideshow is used to cycle through elements. A plugin to display images as a responsive slideshow. Special thanks to Farzad Soltani for his Bootstrap Image Carousel Plugin , that will add a bootstrap carousel with three images (static), but this plugin ( Bootstrap Carousel Extension ) will render a bootstrap carousel region based on query output (dynamic) and changing the slides can be controlled via left and right arrow keys. Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_bootstrap_carousel_extension.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compile it in your schema. Step 2:  Create a

Plug In: Slideshow

Image
A slideshow is used to cycle through elements. A plugin to display images as a responsive slideshow (Display an automatic or manual slideshow). Credits to W3schools . Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_slideshow.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compile it in your schema. Step 2:  Create a new blank page. Step 3:  Export plugin file  " region_type_plugin_orclking_slideshow .sql"  from  GitHub  source directory and import it into your application. Navigation: Shared Components ==> Plug-ins ==> Import Plugin will be listed under plug-ins bucket after successful inst

Plug-In: Tag Cloud Chart

Image
It's a Tag Cloud Chart Plug-In. A tag cloud, otherwise known as a word cloud or weighted list, is a visual representation of text data. This chart is typically used to show keyword metadata (tags) on websites, or to visualize free form text. Tags are usually single words, and the importance of each tag, which is often based on its frequency, is shown with font size or color. It makes the visualize of complex data easy and understand it at a glance.  This has been inspired by   anychart.com . Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_tag_cloud.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compil

Plug-In: Heat Map Chart

Image
It's a Heat Map (or heatmap) Chart Plug-In. It's a visual representation of data where values are depicted by color. It makes the visualize of complex data easy and understand it at a glance.  This has been inspired by   anychart.com . Plug-In Details: DB versions:  12.1.0.1, 12.2.0.1, 18.4.0.0, 19.0.0.0.0, 19.2.0.0.19, 21.0.0.0.0, 21.1.0.0.0, 21.1.0.0.1 APEX versions:  20.1.0.00.13, 20.2.0.00.20,  21.1.0 GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "region_type_plugin_orclking_heat_map_chart.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export a script  "Script to Populate Sample Data.sql"  from directory and compile it in your schema. Step 2:  Create a new blank page. Step 3:  Export plugin file  "region_type_plugin_orclking_heat_map_chart.sql"  from  GitHub  source directory and import it into your application. Navigation: Shared Components ==> Plu