update on classic report oracle in apex

Опубликовано: 03 Апрель 2026
на канале: Md. Mostafa Kamal

1,335

====Classic Report Query=====
select employee_id, first_name, apex_item.hidden(01,employee_id)||apex_item.TEXT(02,COMMISSION_PCT) as Commission from employees;

====Update Process=======
FOR i in 1..APEX_APPLICATION.G_F01.COUNT LOOP
update employees set commission_pct=APEX_APPLICATION.G_F02(i) where EMPLOYEE_ID=APEX_APPLICATION.G_F01(i);
END LOOP;
================
Icons add to navigation menu in oracle apex
   • Icons add to navigation menu in oracle apex

Report region auto refresh in oracle apex
   • Report region auto refresh in oracle apex

Alert message in oracle apex | Plugin alert message in apex
   • Alert message in oracle apex | Plugin aler...

Button Color Using CSS Class in Oracle Apex | Apex Button
   • Button Color Using CSS Class in Oracle Ape...

List of value in oracle apex | LOV in oracle apex
   • List of value in oracle apex | LOV in orac...

Add mandatory sign star on a item in oracle apex | Oracle
   • Add mandatory sign star on a item in oracl...

Custom success message in oracle apex | Alert message
   • Custom success message in oracle apex | Al...