Beejartha

Categories
Oracle APEX

Oracle APEX QR Code Generator

Hello readers. I see you are interested in learning about the QR Code generation using Oracle APEX. Great news, the APEX team has your back! The team has added a QR Code item component to the APEX development toolset. Please allow me to briefly examine the QR (Quick Response) Code and then move on to discuss the QR Code component basics and then you can use your imagination to build the QR Code you are looking for in your APEX application.

What is a QR Code?

A Quick Response (QR) Code serves as a means to instantly retrieve information. Originally, the code was developed in 1994 by a Japanese company to label vehicle parts. The QR Code is a two dimensional barcode that keeps data in a square grid of black and white pixels. When the square barcode is scanned, the arrangement of pixels is handled to quickly direct to the information. QR Codes today have evolved and are becoming more popular. They can store a variety of data, such as web URLs, social media links, product data, and contact details.

What is a QR Code?

In APEX 23.1, a QR Code page item component was introduced.

What is a QR Code?

Select the type of content that this QR code contains, and a corresponding prefix value is inserted in front of the selected source value to affect how the user QR Code scanner will interact with the content. Available options include:

Plain Text

URL:- The URL will open in a browser.

Phone:- Open the phone app with the input number. The phone number can contain special characters ‘(‘ , ‘)’, ‘+’, ‘-‘, ‘.’, and spaces. The exact format of the phone number delegates to the phone’s locale settings.

Email:- Compose a new email to an email address. The expected format of the email address is a valid email address without leading or trailing spaces.

SMS:- Compose a text message to a number. The phone number can contain special characters ‘(‘ , ‘)’, ‘+’, ‘-‘, ‘.’, and spaces. The exact format of the phone number delegates to the phone’s locale settings.

Geo location:- Open a map application to specific coordinates. The expected format of the input coordinates is: latitude, longitude with no leading or trailing spaces.

Add a QR Code page item

There are several ways to add a page item, however, make sure TYPE IS QR CODE. Select the TYPE from the drop-down list, if necessary.

Next, select the QR Code DATA TYPE option from the dropdown list, if necessary. Lastly, select the Source TYPE option from the drop-down list, if necessary. This option type needs to contain
information that is associated with the QR Code DATA TYPE selected.

NOW RUN PAGE!

Yes, the Oracle APEX team has made it that easy!

Credits

  • This tutorial is independently created and is not official Oracle Corporation documentation.
  • The content of this tutorial has been enriched by leveraging the insights and documentation available from Oracle Corporation. We extend our thanks to Oracle for their dedication to knowledge sharing. For official Oracle resources and additional information, please refer to www.oracle.com.
Teresa

By Teresa

I am proficient in Information Technology strategies. Professional experience with relational databases for data ware housing and transactional processing to gather and collect data for essential informational reporting. My career development expertise consists of utilizing client/server solutions and various 3rd generation web technology programming languages. I had the opportunity to develop applications with Oracle Application Express (APEX) using this low code technology installed in an on-premises Oracle database. I have since explored the fully autonomous APEX hosted by Oracle and the Oracle Cloud Infrastructure (OCI) autonomous APEX.

Any Query?

Ask Beejartha