1. 根据向导建立一个interactive report。查询语句可以如下。
select apex_item.hidden(1,e.id) || e.name as staff, apex_item.select_list_from_lov(p_idx=>2,p_value=>e.department_id,p_lov=>'lov_department') as department from employee e; |
2. 创建一个按钮用于提交页面。
3. 创建一个"After Submit' PLSQL process
begin FOR i IN 1 .. apex_application.g_f01.COUNT LOOP update employee set department_id=apex_application.g_f02(i) where id=apex_application.g_f01(i); END LOOP; end; |