About Oracle and Oracle ā'pěks (#orclapex)

May 2022 be the best year of your life. May you find success, happiness and everything your heart desires. Wishing you and your loved ones a very Happy New Year 2022! In 2021, I earned a number of professional achievements that I would like to share with you. 1) My technical blog is listed in top 100 oracle blogs and websites to follow in 2021 2) Awarded member of the month by oracle apex community 3) Promoted to Oracle ACE  ♠ 4) The chief guest of the EEE association inaugural event held by the EEE department at National Engineering College , Kovilpatti, Tamil Nadu, India 5) Earned Oracle Application Express 18: Developer Certified Professional credential 6) Received the Oracle APEX Challenge Coin 7) Earned Oracle Cloud Infrastructure Foundations 2021 Associate credential 8) Earned Continuous Learner badge from CertiProf   9) Technical Blog Posts: Write, Write, Write and finally I have written 26 technical posts in 2021 . A huge thank you goes out to everyone who follows me, likes m

What is Challenge Coin? A challenge coin is a small coin or medallion, bearing an organization's insignia or emblem and carried by the organization's members. Traditionally, they might be given to prove membership when challenged and to enhance morale. What is Oracle APEX Challenge Coin? It is a challenge coin which will be sponsored by an Oracle apex community member who appreciates your contribution in this community. In November 2021,  I received the Oracle APEX Challenge Coin for my significant contributions to the Oracle APEX community. Hard work Pays off!!!  Adrian Png tweeted this, Congratulations @tkarkuvelraja ! @sridharSunila has sponsored you an APEX Challenge Coin. It's in the mailbag and heading your way. Congratulations again and thank you for all your contributions to the community! #orclapex #challengecoin pic.twitter.com/28nUqNupa6 — Adrian Png 🧡🕯️ (@fuzziebrain) November 12, 2021 Here's my tweet: Thanks for honoring me with the APEX Ch

With the APEX_DATA_EXPORT package, you are able to export data from Oracle Application Express in the following file types: PDF, XLSX, HTML, CSV, XML, and JSON. Step 1: Create a table and populate it with some sample records. CREATE TABLE emp   (     empno        NUMBER,     first_name   VARCHAR2(240),     last_name    VARCHAR2(240),     mgr          NUMBER,     deptno       NUMBER,     sal          NUMBER,     created_date TIMESTAMP (6),     comm         NUMBER,     hiredate     DATE,     JOB          VARCHAR2(240),     ename        VARCHAR2(240),     PRIMARY KEY (empno) USING INDEX ENABLE   ); /    INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (1, 'Larry', 'Ellison', ,                  10, 5000, LOCALTIMESTAMP);   INSERT INTO emp (empno, first_name, last_name, mgr,                   deptno, sal, created_date)         VALUES                 (2, 'Juan', 'Juan', 1,  

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 and above GitHub Project Page  |  Download  |  Demo Installation: Go to  GitHub  and export plugin file  "item_type_plugin_orclking_image_zoom.sql"  from Source directory and import it into your application. Steps to Achieve: Step 1:  Export plugin file  "item_type_plugin_orclking_image_zoom.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 Zoom [Plug-In] . Note:  You can define image URL using page item or

What is Oracle ACE Program? The  Oracle ACE Program  is designed to recognize and reward members of the Oracle Technology and Applications communities for their contributions. The Oracle ACE Program award is given for a  one year term  and past members are  Oracle ACE Alumni . In September 2020, I became an Oracle ACE Associate but today  (12-Aug-2021)  I am happy to announce that I have been promoted and recognized as an  Oracle ACE . Thanks  Oracle  and  Oracle ACE Program  to honored me as an Oracle ACE Program Member and for this wonderful award. Hard work Pays off!!!.  I have received the  Oracle ACE Award  (based on my significant contributions and activity in the oracle technical community) and my profile has been added in the  Oracle ACE Directory . What else I need more? Perfection lies in doing ordinary things extraordinarily well, Perseverance and Perfection has led me to this  Oracle ACE Award , would like to dedicate this award to  Joel Kallman  (Former Vice President, So

Requirement:   The objective is to add an image as watermark to source image which is stored an Oracle database. What is the purpose of a watermark on a image? Using watermarks will prevent anyone (even your competitors) from making use of your images . If you implement them, it will help you protect your work and discourage anyone who wants to use your image to promote their project or business from doing so without your permission. What is Oracle Multimedia ORD_IMAGE PL/SQL Package? Oracle Multimedia provides the  ORD_IMAGE PL/SQL package . This package provides functions and procedures to perform common operations such as importing and exporting image data to and from operating system files, extracting metadata from and writing metadata to image data, generating thumbnail images, and  converting the format of image data . This package adds Oracle Multimedia support to image data stored in BLOBs and BFILEs. The following procedure ( apply_image_watermark ) will add an image as a wate

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 

  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