Computersight -

SQL> create table table1 (keytable1 varchar2(10), valuetable1 number);

Table created.

SQL> create table table2 (keytable2 varchar2(10), valuetable2 number);

Table created.

SQL> insert into table1 values (’A',10);

1 row created.

SQL> insert into table1 values (’B',20);

1 row created.

SQL> insert into table2 values (’A', 5);

1 row created.

SQL> commit;

Commit Complete.

SQL> select keytable1, valuetable1 – valuetable2
  2  from table1,table2
  3  where keytable1 = keytable2(+)
  4  /

keytable1 valuetable1-valuetable2
———- ————————-
A                                  5
B

SQL> ed
Escrito fichero afiedt.buf

  1  select keytable1, nvl(valuetable1 – valuetable2, valuetable1)
  2  from table1,table2
  3* where keytable1 = keytable2(+)
SQL> /

keytable1 NVL(valuetable1-valuetable2,valuetable1)
———- ——————————————–
A                                                     5
B                                                    20