Oracle 9 Joins

[scrat]

Hi,

Could anyone please confirm whether the old Oracle method of doing table joins with the (+) syntax still works on Oracle 9. It seems as though O9 supports ANSI standard join syntax like ...from courses c INNER JOIN enrolment e...

I need to assess the impact of migrating to O9 without the luxury of being able to test, so any assistance would be appreciated.

thanks,
scrat

 

[AOLEURO]

Hi

Yes (+) still works.

And yes - Oracle supports ANSI SQL.

And the performance is the same. Oracle still continues to support (+) - and they have no plans for dropping it.


Regards
Allan
Icq: 346225948
! If you can't prove it - don't bother try to teach me !

 

[scrat]

Many thanks Allan.