How To make an Inventory App in Oracle Apex(Step By Step Guide) || Tech Genius
🔷 STEP 1: Create Table (Database)
Open Oracle APEX
Go to SQL Workshop → SQL Commands
Paste this and click Run:
CREATE TABLE INVENTORY (
ID NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
PRODUCT_NAME VARCHAR2(100),
CATEGORY VARCHAR2(50),
QUANTITY NUMBER,
PRICE NUMBER
);
✅ Done → Your database is ready
🔷 STEP 2: Create App
Go to App Builder
Click Create
Click New Application
Now fill:
App Name: Inventory Management System
Click Create Application
🔷 STEP 3: Create Report Page (IMPORTANT)
Click Add Page
Select Report
Choose Interactive Report
Now fill:
Page Name: Inventory Report
Table Name: INVENTORY
Click Add Page
✅ This page shows all products
🔷 STEP 4: Create Form Page (MOST IMPORTANT)
Click Add Page
Select Form
Choose Form on a Table
Now fill:
Page Name: Add / Edit Product
Table Name: INVENTORY
Click Next
👉 VERY IMPORTANT STEP:
You will see option:
Report Page
Select:
👉 Inventory Report
Now click Create
🔷 STEP 5: Run App and Check
Click Run ▶️
Now you will see:
Page 1: Inventory Report
Empty table (no data yet)
👉 Look for button:
Create or Add
Click it
Page 2: Add / Edit Product (Form)
Fill data:
Product Name: Laptop
Category: Electronics
Quantity: 5
Price: 80000
Click Save
Now go back to Report
✅ You will see your product
👉 Click the product row → it opens form again (Edit working)
Good, now you’re moving to the next level of your project 👍
We’ll add a Supplier section step by step, just like you made Inventory.
Follow exactly.
🔷 STEP 6: Create Supplier Table
Go to SQL Workshop → SQL Commands
Paste and Run:
CREATE TABLE SUPPLIER (
ID NUMBER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
SUPPLIER_NAME VARCHAR2(100),
PHONE VARCHAR2(20),
EMAIL VARCHAR2(100),
COMPANY VARCHAR2(100)
);
✅ Now supplier data can be stored
🔷 STEP 7: Add Supplier Report Page
Go to App Builder
Click your app
Click Add Page
Select Report → Interactive Report
Fill:
Page Name: Supplier Report
Table Name: SUPPLIER
Click Add Page
✅ This will show all suppliers
🔷 STEP 8: Add Supplier Form Page
Click Add Page
Select Form → Form on a Table
Fill:
Page Name: Add / Edit Supplier
Table Name: SUPPLIER
Click Next
👉 VERY IMPORTANT:
Select Report Page → Supplier Report
Click Create
🔷 STEP 9: Run and Test
Click Run ▶️
Now:
Open → Supplier Report
Click Add Supplier
Fill:
Supplier Name: Ali Traders
Phone: 03001234567
Email: ali@gmail.com
Company: Ali Electronics
Click Save
✅ You should see data in report.
You see the video link given below for step by step guide just click on the youtube button:
Post a Comment