title: How to make accounting balance report?
body: <p>I'm new to Oracle apex and SQL. I am developing an Oracle app for accounting. My table <code>ga_voucher</code> contains the following columns with values like:</p>
  <pre><code>VNO | DBIT CODE | AMOUNT | CREDIT CODE  |  VDATE       | NARRATION
  01      121005     40000       331001    09/07/2021    ABCD
  02      331002    50000        121005    09/07/2021
  </code></pre>
  <p>I want to generate report with unique account code balance (debit total of a code - credit total) like:</p>
  <pre><code>Account CODE | DEBIT TOTAL|CREDIT TOTAL | BALANCE
  331002           50000    | 40000       |  10000
  </code></pre>
  <p>What is the SQL query for the report? Please help me.</p>