New Image Upload & QR Code Page Items in Oracle APEX

This tutorial demonstrates how to enhance your web applications using a combination of Oracle APEX's Image Upload and QR Code features. With the Image Upload feature, users can upload images (such as photos, logos, or documents) to your APEX application, providing versatile capabilities for tasks like displaying avatars, attaching documents, or creating image galleries. Meanwhile, the QR Code feature allows you to generate QR codes within your APEX application. QR codes, two-dimensional barcodes, can store diverse information like URLs, text, contact details, Wi-Fi network information, and Geolocation data (Latitude & Longitude). Users can scan these codes with a mobile device or QR code scanner to access the encoded information.
Create Table Code:-
=======================================
CREATE TABLE "EMPLOYEES"
( "EMPID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"EMPNAME" VARCHAR2(25 CHAR),
"EMPIMAGE" BLOB,
"URL" VARCHAR2(100 CHAR),
"EMAIL" VARCHAR2(25 CHAR),
"GEOLOCATION" VARCHAR2(16 CHAR),
CONSTRAINT "EMPLOYEES_PK" PRIMARY KEY ("EMPID")
USING INDEX ENABLE
) ;
Sample Data:-
=======================================
EMPID=21
EMPNAME=David Beckham
EMPIMAGE=To be uploaded using the form page
URL=www.amazon.com/Python-Crash-C...
EMAIL=[e-mail]
GEOLOCATION=41.40338,2.17403
Image Attribution
======================================
www.freepik.com/free-vector/b..." Freepik
www.freepik.com/free-ai-image..." Image By freepik

[@rambooroperr1209]

Nice video. Please make video on APEX COLLECTION by Query. And all apex collections related terms. It would be very helpful.

[@TheFactsPk]

how i can Give Specific Pages Or Module ( like Sales ) Access to an apex Developer he/she only Access that Module or that Pages ONLY? Example: My application has 200Pages, 50 Pages For Sales Module 50 Pages For Purchase Module 50 Pages For Accounts Module 50 Pages For HR Module Now I have 4 Developers one(1) For Sales Module and i want to give him/her sales Module 50 Pages NOW i want that HE/SHE not inter-fair in Other Pages/Module Or even HE/SHE has no ACCESS to other PAGES and same for 2nd,3rd and 4th Developer respectively is This Possible? if YES then Please Suggest Solution

[@tariqmuhammad1119]

Nice video

[@TechMining69]

Thanks 😊

[@nnnn_ee_family]

👍

[@manisankarutube]

I am using Apex 23.1. In the Form Item Type - QR Code Type is not showing.

[@TechMining69]

Update the version to 23.2

[@MahmudHasan-to9xr]

can you do a video for purchase return and sales return. it will be really helpful for us

[@TechMining69]

Sure

[@TheFactsPk]

i need a form For My Project I buy "Solar Panel" With Warranty on base of Bar Code i want to make a IGP(inward Gate pass) with Upload bar code from image Facility same when i sell then i also mention Bar-Code

[@TechMining69]

You can scan the bar code and store the value in your database table. Then you can use the procedure demonstrated in this video to create QR code.

[@TheFactsPk]

Dear @Tech Mining How I can contact you

[@TechMining69]

You can contact me via my email [e-mail]