1. Create 3 button named Insert , Update, Delete
and Enable Edit
2. Create a process On Submit-After Computation and validation.
Copy and Pest the code as PL/SQL
begin
case :APEX$ROW_STATUS
when 'C' then
insert into PRODUCT_STORE ( SERIAL, PRODUCT_SERIAL, PRODUCT_CODE )
values ( :SERIAL, :PRODUCT_SERIAL, :PRODUCT_CODE )
returning rowid into :ROWID;
when 'U' then
update PRODUCT_STORE
set PRODUCT_SERIAL = :PRODUCT_SERIAL
where rowid = :ROWID;
when 'D' then
delete PRODUCT_STORE
where rowid = :ROWID;
end case;
end;
This process is written respecting a table and form item. But you should wright it respecting your table and form item.
Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Subscribe to:
Post Comments (Atom)
How to Implement Password Hide/Show in Login Page
Follow these steps to enable users to toggle between hiding and showing their password on the login page. Step 1: Add the Function and Glob...
-
Search by keyword from Oracle Database Objects. select owner, type, name, line, text from dba_source where 1 = 1 and text like '%TEXT Y...
-
We Can Export Application Components individually from Oracle Apex. Application > Shared Components > Export Application Compo...
No comments:
Post a Comment