Overview
A new page item introduced in APEX 23.2 is the QR Code Generator. This brings QR code generation native to APEX, previously only possible using third-party libraries. The page item allows you to render the QR Code in one of three sizes (small, medium or large) and allows for six different data types to be depicted by the QR Code (plain text, URL, phone, email, SMS or Geo location)
Technologies and Tools Used
The following technologies has been used to achieve the same.
- Oracle APEX
Use Case
Inventory Management: Scan product codes to quickly add items to shopping carts or track stock levels. Link QR codes to detailed product information for faster lookup and customer access.
Event Registration and Attendance: Scan tickets or badges at the entrance for smooth event check-in and access control. Track attendance data and gather feedback by linking surveys to QR codes.
Customer Service and Support: Allow customers to submit feedback or report issues by scanning codes in stores or on receipts. Offer product demonstrations or interactive content accessible through QR code scans.
Marketing and Advertising: Redirect users to landing pages, product demos, or online stores with dynamic QR codes containing custom URLs.
Architecture
Step1: Create a page Interactive report with Form and mapping with EMPLOYEE_1 table. The Employee_1 have following columns.
|
EMPLOYEE_ID |
Number |
|
EMPLOYEE_NAME |
Varchar2 |
| EMPLOYEE_IMAGE |
Blob |
| URL |
Varchar2 |
|
|
Varchar2 |
| GEOLOCATION |
Varchar2 |
| PHONE_NUMBER |
Number |
Step2: Change Page Employee_name, email, URL, phone number and location type as QR CODE in QR_CODE_GENERATOR_FORM.
Step3: QR_CODE type has one special property – Data Types
Step4: The following table will explain briefly about the data type property
|
Plain text |
Plain text, such as messages, notes, or descriptions. |
|
URL |
Website addresses, allowing users to quickly scan and visit web pages. |
|
Phone |
Directly dial the encoded number upon scanning. |
|
|
Open a pre-addressed email ready to send. |
|
Geo Location |
Latitude and longitude coordinates, often used for maps and navigation. |
|
SMS |
Latitude and longitude coordinates, often used for maps and navigation. |
Conclusion
In conclusion, The arrival of the built-in QR code generator in APEX 23.2 isn’t just a new feature; it’s a seismic shift in how we build and interact with applications. Forget clunky workarounds and complex libraries.
Screenshots
RESULT:-
REPORT
FORM
Scanned Via Phone
