Good review here of the free Oracle "Express Edition" (XE) database. I'm waiting (i.e. pushing) for a Mac version, and would like to see it offered by hosting providers.
Oracle XE: It's Not Your Typical Oracle
Regarding the GUI options... I've tried a lot of them, from various sources, and have never been impressed. But SQL Developer (formerly "Project Raptor") is growing on me!