oracle data modeling and plsql code generation tool

Hi,

I am looking for some designer tool that I will able to design my database using UML and through this design I will able to create DDL scripts. We are working on Oracle 10g.

What tools you are using for this purpose and what is your recommendation. ?

thanks for your help.

I know there are a miryad of tools out there to chose from but I've being working with ERWin for about twelve or thirteen years now. It does the trick.

I call ERWin my frontend modeling tool being my backend modeling tool my own brain ;)