A small Oracle Application Express (APEX) application is required.
We have a bar code reader that will be used to scan a barcode. When the barcode is scanned, we would like it to record the scan into the database table EMP_SCANS
We have one table in our application and below is the script for it:
CREATE SEQUENCE "EMP_SCANS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE NOPARTITION
CREATE TABLE "EMP_SCANS"
( "ID" NUMBER,
CREATE OR REPLACE EDITIONABLE TRIGGER "BI_EMP_SCANS"
before insert ON emp_scans
for each row
if :[login to view URL] is null then
select [login to view URL], sysdate, user into :[login to view URL], :new.date_created, :new.created_by from [login to view URL];
ALTER TRIGGER "BI_EMP_SCANS" ENABLE
The Oracle Application Express form that appears should only have one form with one field on it: SCAN_NO
When the barcode is scanned, it should get automatically inserted into the table EMP_SCANS (there will be no submit button on the form), and the form should go to the new record input mode, thereby allowing another scan to be recorded. Attached is an image of the form we require.
As you can see this is a very small and simple application.
16 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
HIGHLY interested with your project. I'm ready to start right now. I'm an individual developer and my completion rate is always 100%. I STRICTLY BITE only WHICH I CAN CHEW. Message me please
I have some tutorials about Oracle APEX on www.developapex.com. Let me do the job and it will be finished by tomorrow. Relevant Skills and Experience Oracle APEX, Oracle PL/SQL
I really want to work on this project as my first freelancer project. I love Oracle Tech: Forms / Reports / PLSQL / Apex and am very good at it. You will not regret. I guarantee.
I have good knowledge and experience of Oracle Apex. I have developed similar kind of task many times for our clients. I can deliver it on given time as per given requirement.
I'm have 11 years of experience in application development using oracle apex. I can build the best looking and functioning applications with oracle apex.