ANSI std not supported

[Raminder]

You can use the (+) operator for outer join in 8i:

select count(*) from TABLE1 a, TABLE2 b
where a.ID1 = b.ID2(+);

Oracle 9i supports the ANSI standard n this regard.