Search This Blog

Saturday, February 24, 2018

Interactive Grid Manual Insert, Update, Delete Button process

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.



No comments:

Post a Comment

Split A String By Coma (,)

Step 1.  create or replace type split_tbl as table of varchar2(32767); Step 2. create or replace function split (     p_list varchar2,...