Xref: alice comp.databases.oracle.tools:26024
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.belnet.be!isdnet!grolier!club-internet!not-for-mail
From: "Sham" <shameemg@club-internet.fr>
Newsgroups: comp.databases.oracle.tools
Subject: SqlPlus question
Date: Sun, 6 Jun 1999 00:44:09 +0200
Organization: Club-Internet (France)
Lines: 19
Message-ID: <7jc987$r68$1@front5.grolier.fr>
X-Trace: front5.grolier.fr 928622663 27848 195.36.160.188 (5 Jun 1999 22:44:23 GMT)
NNTP-Posting-Date: 5 Jun 1999 22:44:23 GMT
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

Hi, I'm looking for a means to solve the following problem in sqlplus :
I have the following columns :

Account       Debit       Credit
=====        ====       ====
a/c1             10               20
a/c1             15              25
Sum             25               45        <- Line calculated in a break ...
compute statement

Now, I want to calculate the difference between the sum of debit and the sum
of credit and display it underneath. The finality of that is to find an
account where sum(debit) is different from sum(credit)

How can I do that ? Thanks for helping me.
Please also reply to shameemg@club-internet.fr