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;
Негізгі бет Custom DML Statement on Interactive Grid
Пікірлер: 1