Code (Text):
:global.var := :global.var + :qty-:issqty;
:run_tot := :global.var;

SELECT
   deptno,
   job,
   count(*),
   sum(sal)
FROM
   emp
GROUP BY
   ROLLUP(deptno,job);

DEPTNO JOB         COUNT(*)   SUM(SAL)
--------- --------- ---------   ---------
       10 CLERK              1       1300
       10 MANAGER            1       2450
       10 PRESIDENT          1       5000
 -->   10                    3       8750
       20 ANALYST            2       6000
       20 CLERK              2       1900
       20 MANAGER            1       2975
 -->   20                    5      10875

SQL> select * from emp;

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
      7566 JONES      MANAGER         7839 02-APR-81       2975                    20
      7654 MARTIN     SALESMAN        7698 28-SEP-81       1250       1400         30
      7698 BLAKE      MANAGER         7839 01-MAY-81       2850                    30
      7782 CLARK      MANAGER         7839 09-JUN-81       2450                    10
      7788 SCOTT      ANALYST         7566 09-DEC-82       3000                    20
      7839 KING       PRESIDENT            17-NOV-81       5000                    10
      7844 TURNER     SALESMAN        7698 08-SEP-81       1500          0         30
      7876 ADAMS      CLERK           7788 12-JAN-83       1100                    20

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7900 JAMES      CLERK           7698 03-DEC-81        950                    30
      7902 FORD       ANALYST         7566 03-DEC-81       3000                    20
      7934 MILLER     CLERK           7782 23-JAN-82       1300                    10

14 rows selected.

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK

        20 RESEARCH       DALLAS

        30 SALES          CHICAGO

        40 OPERATIONS     BOSTON


SQL>
SQL>  select dname,
  2             ename,
  3             sal,
  4             sum(sal) over ( partition by dname
  5                                 order by dname, ename ) dept_running_total,
  6             sum(sal) over ( order by dname, ename ) running_total
  7        from emp, dept
  8       where emp.deptno = dept.deptno
  9       order by dname, ename
 10     /

DNAME          ENAME             SAL DEPT_RUNNING_TOTAL RUNNING_TOTAL
-------------- ---------- ---------- ------------------ -------------
ACCOUNTING     CLARK            2450               2450          2450
               KING             5000               7450          7450
               MILLER           1300               8750          8750

RESEARCH       ADAMS            1100               1100          9850
               FORD             3000               4100         12850
               JONES            2975               7075         15825
               SCOTT            3000              10075         18825
               SMITH             800              10875         19625

SALES          ALLEN            1600               1600         21225

DNAME          ENAME             SAL DEPT_RUNNING_TOTAL RUNNING_TOTAL
-------------- ---------- ---------- ------------------ -------------
SALES          BLAKE            2850               4450         24075
               JAMES             950               5400         25025
               MARTIN           1250               6650         26275
               TURNER           1500               8150         27775
               WARD             1250               9400         29025


14 rows selected.

I HAVE TWO COLUMN QUERIED FROM TABLE ON FORM BUILDER [NEED BALANCE] LIKE THIS...
  DEBIT CREDIT [BALANCE]
    1     0      [1]
    0     1      [0]
    2     0      [2]
    0     1      [1]
   ---   ---     ---
   (3)   (2)     
(CALCULATED USING CALCULATION SUMMARY)
[HOW TO CALCULATE BALANCE LIKE ABOVE]

I HAVE TWO COLUMN QUERIED FROM TABLE ON FORM BUILDER [NEED BALANCE] LIKE THIS...
  DEBIT CREDIT [BALANCE]
    1     0      [1]
    0     1      [0]
    2     0      [2]
    0     1      [1]
   ---   ---     ---
   (3)   (2)     
(CALCULATED USING CALCULATION SUMMARY)
[HOW TO CALCULATE BALANCE LIKE ABOVE]

go_block('block2');
set_block_property('block2', default_where, '');
execute_query;

if :block1.text1 is not null then
	set_block_property ('block2', default_where, 'block1 = :block1.text1');
end if;

  DEBIT CREDIT [Closing]
    1     0      [1]
    0     1      [0]
    2     0      [2]
    0     1      [1]
   ---   ---     ---
   (3)   (2)     (1)
(CALCULATED USING CALCULATION SUMMARY)
[HOW TO CALCULATE BALANCE LIKE ABOVE]

create table foo (col1 varchar2(10), col2 number(10));

insert into foo (col1, col2) values ('A',1);
insert into foo (col1, col2) values ('B',2);

CREATE TABLE table1(Debit NUMBER(12,3) DEFAULT 0.000,Credit NUMBER(12,3) DEFAULT 0.000);
insert into table1 (Debit, Credit) values ('1',0);
insert into table1 (Debit, Credit) values ('0',1);
insert into table1 (Debit, Credit) values ('2',0);
insert into table1 (Debit, Credit) values ('0',1);

SQL> CREATE TABLE table1
  2  (
  3  Debit NUMBER(12,3) DEFAULT 0.000,
  4  Credit NUMBER(12,3) DEFAULT 0.000,
  5  );
)
*
ERROR at line 5:
ORA-00904: : invalid identifier

CREATE TABLE table1(Debit NUMBER(12,3) DEFAULT 0.000,Credit NUMBER(12,3) DEFAULT 0.000);
insert into table1 (Debit, Credit) values (1,0);
insert into table1 (Debit, Credit) values (0,1);
insert into table1 (Debit, Credit) values (2,0);
insert into table1 (Debit, Credit) values (0,1);

DROP TABLE TABLE1;
CREATE TABLE table1(VRNO NUMBER(5),Debit NUMBER(12,3) DEFAULT 0.000,Credit NUMBER(12,3) DEFAULT 0.000);
insert into table1 (VRNO, Debit, Credit) values (1,1,0);
insert into table1 (VRNO, Debit, Credit) values (2,0,1);
insert into table1 (VRNO, Debit, Credit) values (3,2,0);
insert into table1 (VRNO, Debit, Credit) values (4,0,1);

SQL> select vrno, debit, credit,
  2         sum(credit-debit) over (order by vrno) balance
  3  from table1
  4  order by vrno
  5  /
      VRNO      DEBIT     CREDIT    BALANCE
---------- ---------- ---------- ----------
         1          1          0         -1
         2          0          1          0
         3          2          0         -2
         4          0          1         -1

select vrno, debit, credit, sum(credit-debit) over (order by vrno) balance from table1 order by vrno