Back to Browse

Custom DML Statement on Interactive Grid

1.1K views
Sep 14, 2024
8:49

How to write custom DML statement (Insert, Update, Delete) on Interactive Report in Oracle APEX. BEGIN -- It runs row by row for interactive grid IF :APEX$ROW_STATUS = 'D' THEN -- Delete the record ELSIF :APEX$ROW_STATUS = 'C' THEN -- Insert the record ELSIF :APEX$ROW_STATUS = 'U' THEN -- Update the record END IF; END;

Download

1 formats

Video Formats

360pmp413.3 MB

Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.

Custom DML Statement on Interactive Grid | NatokHD