Posts

Image
 HOW TO CHECK ALL CHECKBOX IN IN INTERACTIVE GRID ORACLE APEX? 1. Set static ID in IG 2. create one item supposed P5_CHECKBOX_ALL  VALUES: 1 FOR CHECKED,0 FOR UNCHECKED 3. use Dynamic action on P5_CHECKBOX_ALL  and use below code // Get the Interactive Grid widget instance var ig$ = apex.region("roles_assign").widget(); var model = ig$.interactiveGrid("getViews", "grid").model // Loop through all records in the interactive grid model.forEach(function(record) {  // Access the column value and update it  var newValue = 1; // Specify the new value here  var val = apex.item('P5_CHECK_ALL').getValue();  model.setValue(record,'ADDING', val);  model.setValue(record,'DELETING', val);  model.setValue(record,'UPDATING', val);    });
Post a Comment
Read more
 HOW TO CREATE API AND VIEWS FROM ORACLE APEX COLLECTION? Using the following codes to generate Package and package specification, body and view and trigger  /* INSTALL INSTRUCTIONS In the target schema: - create package spec and package body (apex_collections_dml_pkg) - create view (APEX_COLLECTIONS_DML) - create instead of trigger (APEX_COLLECTIONS_DML_TRG) Actually, You can simply execute the following script */ CREATE OR REPLACE PACKAGE apex_collections_dml_pkg AS TYPE t_coll IS TABLE OF apex_collections%ROWTYPE; FUNCTION get_coll_data RETURN t_coll PIPELINED; END apex_collections_dml_pkg; / CREATE OR REPLACE PACKAGE BODY apex_collections_dml_pkg AS FUNCTION get_coll_data RETURN t_coll PIPELINED IS     CURSOR c_data IS         SELECT *         FROM apex_collections;     lrData t_coll; BEGIN     OPEN c_data;          LOOP         FETCH c_data BULK COLLECT INTO ...
Post a Comment
Read more
Image
How to add shortcut Key in oracle apex Interactive Grid?  Action Description Customized Shortcut row-add-row Insert a row straight after the current row Alt + A row-delete Delete the current row Alt + D save Save the current data changes. Note: Interactive Grid must be editable Alt + S refresh Refresh the Interactive Grid region Alt + R reset-report Reset the current report settings Alt + C focus Focus on Interactive Grid's Search Bar. This action is not included in the widget. Alt + F Follow the following steps: Using this code in Interactive Grid Attributes and JavaScript initializations function( options ) {     //Tab and Shift-Tab will skip over cells that are read-only     options.defaultGridViewOptions = {           skipReadonlyCells: true       };            options.initActions = function( actions ) {                   ...
Post a Comment
Read more
Image
  Today I am going to describe the   Difference Between Union And Union All in Oracle Database . The  Union  is an  Operator  that is used to combine two or more select statement data into a single unit or display a single result.  Union  removes duplicate data from the result set while  Union All  is also an Operator that is used to combine two or more select statement data into a single unit or display a single result.  Union All  do not remove duplicate data from the result set. Let's Start Today Topic. What is the  Union  Operator in Oracle Database ? What is the  Union All  Operator in Oracle Database ? Basic  Difference between Union and Union All in Oracle Database What is the Union  Operator in Oracle Database ? The  Union  is an Operator that is used to combine two or more select statement data into a single unit or display a single result. Union  removes duplicate...
Post a Comment
Read more
Image
 how to Remove success message in oracle apex 20.1 20.2 and any lower versions? step no 1:go to dynamic actions and make one dynamic action on page load like the following figure 01  step no 2: make true action and set action execute javascript code step no 3: Write the following function in setting code setTimeout(function(){  $('#APEX_SUCCESS_MESSAGE').fadeOut('fast'); },3000) and save it it will remove success message when any submit buttons are clicked  Subscribe our channel in youtube :Najeeb Alikel  https://www.youtube.com/results?search_query=najeeb+alikhel
Post a Comment
Read more
Image
 how to user javascript function to open a model in oracle Apex 20.1 19.1 or any version? First create two regions one for button which should be normal and second  should be model with some data like the following and static id is IRreport         Create one button in the first region button_region and its dynamic actions will be like this        the above js function should be created on page based in function and global variable declaration  like in the following  Note: Remember we IRreport .it is the static id of that model report For Closing the report  1. create another function in global area and write instead of open close         subscribe our channel : Najeeb Alikhel  https://www.youtube.com/results?search_query=najeeb+alikhel
Post a Comment
Read more
Image
 how to use dynamic action hide and show in oracle apex 20.1 version? step 1: Create two regions one for single item select list  and second for emp report  as the following  the first region should be static content and with one item  p3_select_list and lOV Static  values: show and hide second region is report  interactive report  sql query: select * from employees; dynamic action is on click and true action is: false action: this is a final output    najeebalikhel@gmail.com youtube channel : Najeeb Alikhel subscribe our channel for videos  https://www.youtube.com/results?search_query=najeeb+alikhel
3 comments
Read more