Oracle Application Express Keyboard Shortcuts

Where Keys Action
Page Designer Grid Layout CTRL+ALT+D Display from here
Page Designer Grid Layout CTRL+ALT+T Display from page
Page Designer Alt+2 Go to Dynamic Actions
Page Designer Alt+9 Go to Gallery Buttons
Page Designer Alt+8 Go to Gallery Items
Page Designer Alt+7 Go to Gallery Regions
Page Designer Alt+5 Go to Grid Layout
Page Designer Alt+F1 Go to Help
Page Designer Ctrl+F1 Go to Messages
Page Designer Alt+4 Go to Page Shared Components
Page Designer Alt+3 Go to Processing
Page Designer Alt+6 Go to Property Editor
Page Designer Alt+1 Go to Rendering
Page Designer Alt+Shift+F1 List Keyboard Shortcuts
Page Designer Ctrl+Alt+F Page Search
Page Designer Ctrl+Y Redo
Page Designer Alt+F11 Restore/Expand
Page Designer Ctrl+Alt+S Save
Page Designer Ctrl+Alt+R Save and Run Page
Page Designer Ctrl+Alt+E Toggle Hide Empty Positions
Page Designer Ctrl+Z Undo
Page Designer with focus anywhere that has a context menu Shift+F10 or Context menu key Open context menu
Page Designer Grid Layout Gallery and Icon List in wizards Arrow keys Move selection
Page Designer Property Editor with focus on a group heading Up/Down Arrow keys Move to previous/next group
Page Designer Property Editor with focus on a group heading Home/End keys Move to first/last group
Page Designer Property Editor with focus on a group heading Left/Right Arrow keys or Enter or Space Expand or collapse the group
Page Designer With focus on any tab Arrow keys Select previous/next tab
Focus on a splitter handle Arrow keys Move splitter
Focus on a splitter handle Enter Expand or collapse splitter if supported by splitter
On pages that have a splitter Ctrl+F6 Move to next splitter
On pages that have a splitter Ctrl+Shift+F6 Move to previous splitter
Focus on any field with a (?) help icon Alt+F1 Open field help dialog
Focus on a field help dialog Alt+F6 Move focus back to field without closing dialog
Focus in any dialog Escape Close dialog
Any page, focus on region display selector "tabs" Arrow keys Select the previous/next tab
SQL Commands Ctrl+Enter Run the current command
Code Editor Ctrl+Z Undo
Code Editor Ctrl+Shift+Z Redo
Code Editor Ctrl+F Find
Code Editor Ctrl+Shift+F Replace
Code Editor with focus in find field Up/Down Arrows Find previous/next instance
Code Editor Ctrl+Space Auto complete when available
Code Editor Alt+F6 Leave code editor and go to next tab stop
Code Editor Alt+Shift+F6 Leave code editor and go to previous tab stop

Auto Reload / Refresh A Page After a Certain Time In Oracle Apex

Auto Reload / Refresh A Page In Oracle Apex is very simple.

Just copy-pest the code on Page Properties >> HTML Header 

<meta http-equiv="refresh" content="3" >

This 3 is the number of second  between every Reload / Refresh of the Page.

Check Or Click and Get Details Report

Step 1. Create a Interactive Grid Editable Form by you query.

Step 2. Create another item to keep details report query parameter from Master Table. \

Step 3. Create a Dynamic Action on Master region with  Selection Change [Interactive Grid]  Event
           and Execute JavaScript Action.
           Copy Pest the code:

    var i, selectedIds=":" ,
    model = this.data.model;

for ( i = 0; i < this.data.selectedRecords.length; i++ ) {
    if (i>=0) { 
    selectedIds += model.getValue( this.data.selectedRecords[i], "EMPNO") + ":"; }  // Matching column (parameter) 
    else 
        {
    selectedIds += model.getValue( this.data.selectedRecords[i], "EMPNO");   // Matching column (parameter) 
       }
}
$s("P8_NEW", selectedIds);   //Item to keep parameter Value from master Table
apex.region("ID").refresh();
   
Step 4. Finally create another report to show details report with you query and using master table matching column. And do the condition like this.

select EMPNO,
       ENAME,
       JOB,
       MGR,
       HIREDATE,
       SAL,
       COMM,
       DEPTNO
  from EMP
 where instr(:P8_NEW, ':' ||EMPNO|| ':' ) > 0 ;

--------------------------------That's All------------------------Thank You ---------------------------

Get Summation Doing Checkbox Checked In Oracle Apex Via JavaScript

To Get Summation By Doing Checkbox Checked In Oracle Apex Via JavaScript.

Step 1. Create a CheckBox item and with Some  Numbers by Query or Static. Like :

     select 100,100 a from dual
     union
     select 200,200 a from dual
     union
     select 300,300 c from dual

Step 2. Create another item with  Textfield type to show summation result .

Step 3. Now Copy-Pest the function to

Page Properties  > Function and Global Variable Declaration 

/* P43_SUM = Textfield item ID where we show the result.
P43_NEW = Checkbox item from where we get value. 
P43_NEW_ = First portion of every Checkbox ID . */

 function findTotal() {
        var arr = document.getElementsByName('P43_NEW');
        var tot = 0;
        var count= 0 ;
    for (var i = 0; i<arr.length; i++) {  
        if ($('#P43_NEW_'+i).prop('checked') == true) {      
            count = count + 1 ;
            tot += parseInt(arr[i].value);
        document.getElementById('P43_SUM').value =  tot;
         }
         else  if (count == 0 ){
               document.getElementById('P43_SUM').value =  0;
         }         
      }
    } 

Step 4. Finally  Call the JavaScript Function Like.
Checkbox item properties > Advanced  > Custom Attributes

     onchange="findTotal();"

-------------------------------------Thank You----------------------------------

Apex them API to Change Color of Them

apex_theme.set_session_style( p_theme_number =>   42,
                                                  p_name =>     'Vita - Red'  );

Login Time Apex Them Color Mention.