How to Create Form on Blank Page in Oracle APEX | Manual Data & Photo Save скачать в хорошем качестве

How to Create Form on Blank Page in Oracle APEX | Manual Data & Photo Save

Doston, is video mein hum dekhenge ki Oracle APEX mein ek Blank Page par custom Form kaise banate hain. Hum ismein Automatic DML use nahi karenge, balki ek Manual INSERT Query ke zariye data aur Photo (File Upload) ko table mein save karna seekhenge. Ye method real-world applications mein bahut kaam aata hai jab aapko file upload aur data processing par poora control chahiye hota hai. -------------------------------------------------- ✅ STEP 1: CREATE PAGE ITEMS (BLANK PAGE) -------------------------------------------------- 🔹 EMP_CODE → P8_EMP_CODE (Text Field) 🔹 EMP_NAME → P8_EMP_NAME (Text Field) 🔹 DEPARTMENT → P8_DEPARTMENT (Select List / Text Field) 🔹 DOB → P8_DOB (Date Picker) 🔹 DOJ → P8_DOJ (Date Picker) 🔹 EMP_PHOTO → P8_PHOTO (File Browse) 📌 Important (File Browse Settings) 🔹 Storage Type → APEX_APPLICATION_TEMP_FILES 🔹 Allow Multiple File → No -------------------------------------------------- ✅ STEP 2: CREATE SAVE BUTTON -------------------------------------------------- 🔹 Button Name : SAVE 🔹 Action : Submit Page -------------------------------------------------- ✅ STEP 3: ADD PL/SQL PROCESS (AFTER SUBMIT) -------------------------------------------------- 🔹 Process Name : INSERT_EMPLOYEE 🔹 Process Type : PL/SQL Code 🔹 Execution : After Submit 📌 PL/SQL Code Used: DECLARE l_blob BLOB; l_mime_type VARCHAR2(255); l_file_name VARCHAR2(255); BEGIN -- Fetch uploaded file SELECT blob_content, mime_type, filename INTO l_blob, l_mime_type, l_file_name FROM apex_application_temp_files WHERE name = :P8_PHOTO; -- Insert data into table INSERT INTO EMPLOYEE_DETAIL ( EMP_CODE,EMP_NAME,DEPARTMENT, DOB,DOJ, EMP_PHOTO,EMP_PHOTO_TYPE,EMP_PHOTO_NAME, ADDED_BY,ADDED_ON,STATUS ) VALUES ( :P8_EMP_CODE,:P8_EMP_NAME,:P8_DEPARTMENT, TO_DATE(:P8_DOB,'DD-MON-YYYY'),TO_DATE(:P8_DOJ,'DD-MON-YYYY'), l_blob,l_mime_type,l_file_name, :APP_USER,SYSDATE,'Active' ); COMMIT; END; -------------------------------------------------- ✅ STEP 4: SUCCESS MESSAGE -------------------------------------------------- 🔹 Employee saved successfully -------------------------------------------------- ✅ STEP 5: OPTIONAL (AFTER SAVE ACTION) -------------------------------------------------- 🔹 Clear page items after save 🔹 OR redirect back to the Report page -------------------------------------------------- 🔑 KEY POINTS -------------------------------------------------- ✔ Form ko Blank Page par banaya gaya hai. ✔ Automatic DML ki jagah Manual INSERT ka use kiya hai. ✔ File upload ke liye APEX_APPLICATION_TEMP_FILES ka logic use hua hai. ✔ File name aur type ko alag columns mein store kiya gaya hai. ✔ Ye method modal popup aur custom layouts ke liye best hai. -------------------------------------------------- 🛠 TECHNOLOGY USED -------------------------------------------------- 🔹 Oracle APEX 🔹 Blank Page Form 🔹 Manual INSERT (PL/SQL) 🔹 File Upload (BLOB) 🔹 SQL -------------------------------------------------- 🎵 BACKGROUND MUSIC CREDIT Music:Ikson Musician:ikson.com/track/21/discover -------------------------------------------------- -------------------------------------------------- 📌 NOTE -------------------------------------------------- This example uses demo data for learning purposes only. No production or company data is used. Ye video sirf educational purpose ke liye hai. Demo data ka use kiya gaya hai taaki aap log asani se seekh sakein. ---------------------------------------------------