Each Tool is developed keeping specific professional in mind. Couple of tools for Application developers perspective and couple of 'em from DBA's perspective and few from both perspectives.

You have to Justify your requirements...

Application Developers:
TOAD/SQL Navigator/EZ SQL/Precise SQL
DBAs:
OEM
DBArtisian
Precise Enterprize
Other Platinum/BMC Products