title: How to Use AJAX or Dynamic Actions to Refresh one Table on a Page in Oracle Apex?
body: <p>I have two Main reports. Each report has a corresponding region with a Nonmain Classic report (so 4 reports total). Clicking on a link in each of the Main reports reveals details in its corresponding Nonmain report.</p>
  
  <p>Currently, clicking on a Main report will reload the whole page, and all the PL/SQL and SQL has to refire from all 4 reports.</p>
  
  <p>It would cut down on the SQL calls if only the nonmain report refreshed. I assume AJAX would be the best bet to accomplish this.</p>
  
  <p>How would I go about doing such a task?</p>
  
  <p>Thank you.</p>
  
  <p>P.S., all four reports are determined by a PL/SQL function returning a SQL statement. All headings also are determined by a PL/SQL function returning a colon-delimited string. </p>