Use Dynamic Actions To Update Data

This tutorial will create a dynamic action named 'CALCULATE COMMISSION'. This fires whenever the 'Job' or 'Salary' page items change. Upon change, it does two things. Firstly an AJAX call is fired that retrieves the calculated commission (based on the current values for 'Job' and 'Salary') from calling a PL SQL function. The 'Commission' page item is then set to the calculated commission. It is based on one native action ('Set Value' with a 'Set Type' of 'PL SQL Function Body').
And one dynamic action called 'GET DEPT INFORMATION'. This fires whenever the 'Department' page item changes and invokes an AJAX call that retrieves the 'Location' and 'Number of Employees' information for the selected department from the database. It uses one native action ('Set Value' with a 'Set Type' of 'SQL Statement').
And one dynamic action called 'UPDATE SALARY' is associated with the button on the page. This uses the 'Execute PL SQL Code' event type to update the employee salaries and then uses the 'Refresh' event type to show the updated values in the report.
Source Code Link
===============================================
drive.google.com/drive/folder...
00:00 - Introduction
01:30 - Update Salary
04:49 - Get Dept Information
08:00 - List Of Value (LOV) Calc Commission
09:01 - Calculate Commission

[@tamtamatube]

i love your videos,and i am waiting for it every day

[@TechMining69]

Dear, It's impossible to upload every day😄. It requires a lot of effort

[@vijayalaxmianchanala709]

Hi can you please help me with a problem... I have an Interactive grid with few selected rows... I want to disable unselection/selection for those selected rows.. once a button is clicked

[@user-dd9dc1mq8j]

I am beginner in oracle Apex and learn from your videos Thanks brother keep it up

[@TechMining69]

Dear User, this playlist is only for intermediate and advance users 😯

[@user-dd9dc1mq8j]

@@TechMining69 😍

[@tamtamatube]

i am new in oracle apex