What is diff

Cap2010 · Jul 21, 2004

Hi,

Is there a command "diff" in Oracle 8/8i sql.

Where can i find further details.

Cap

alexhu · Jul 21, 2004

Not as far as I know

There is one in UNIX though

Alex

carp · Jul 21, 2004

What is it that you are trying to "diff"?

Cap2010 · Jul 21, 2004

I am trying to find difference from 1 row with next row in the same table

Cap2010

sem · Jul 21, 2004

Use minus sql operator:

Code:

select <field1, .., fieldN> from <table>
where <condition1>
minus
select <field1, .., fieldN> from <table>
where <condition2>

Regards, Dima

nagornyi · Jul 22, 2004

Code:

selecr a.field - b.field
from
  (select field, rownum num from table) a
, (select field, rownum num from table) b
where a.num = b.num-1