Muhammad Abdul Qaium is a Database Engineer/Oracle Apex Developer/BI Developer (in Connecticut, USA) who is an Oracle Certified Cloud Architect Professional, OCI Autonomous DB specialist as well as Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist with extensive expertise in Database design , PL/SQL, Oracle Apex, Microsoft SSIS, ETL, Power BI, Qlik Sense, BI Publisher, Jasper Report, OBIEE. Contact: qaiuminfo@gmail.com
Search This Blog
Monday, February 5, 2018
How to Make A Check Box and Check mark Individual or Multiple In Oracle Apex 5.1
1.
select
column1, column2, column3,
APEX_ITEM.CHECKBOX(10,'#ROWNUM#') "CHKBOX"
from TABLE_NAME
Go to Report Attributes ->(Respective Check Box) Column Attributes->Display As -> Standard Report Column
Go to Report Attributes ->(Respective) Column Attributes->Display As -> Display as text
2.
declare
V_ROW NUMBER;
begin
FOR i IN 1..APEX_APPLICATION.G_F10.COUNT LOOP
V_ROW := APEX_APPLICATION.G_F10(i);
update TABLE_NAME
set
Column3='Y'
where column1=APEX_APPLICATION.G_F01(V_ROW);
--RAISE_APPLICATION_ERROR(-20001,APEX_APPLICATION.G_F08(v_row)||v_row);
--RAISE_APPLICATION_ERROR(-20001,APEX_APPLICATION.G_F01(V_ROW));
--APEX_APPLICATION.G_F01(V_ROW)||
END LOOP;
end;
3. Do This JavaScript
$('#P106_CHCKALL').change(function() {
var checkboxes = $(this).closest('form').find(':checkbox');
if($(this).is(':checked')) {
checkboxes.prop('checked', true);
} else {
checkboxes.prop('checked', false);
}
});
Go to Report Attributes and Copy Pest it on the Report Attribute -> Heading
<input type="checkbox" id="P106_CHCKALL" />
OR
<input type="checkbox" onclick="$f_CheckFirstColumn(this)" />
Subscribe to:
Post Comments (Atom)
Error From Interactive Grid - Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row locking.
Error: Process ' Process- Save Interactive Grid Data' raised 'ORA-0000: normal, successful completion' while performing row ...
.png)
-
Create Excel File From Classic Report in Oracle Apex Using Java Script 1. Upload File Download File 2. Copy Pest the Code <!DO...
-
Version 11 g 1. 11g have not PDB (Pluggable Database) 2. 11g (g for Grid Computing) 3. Released in 2008 4. Dose Not have Cloud Support 5. ...
No comments:
Post a Comment