Oranna is and Oracle client Application. Oranna provides a GUI interface for the user to look at and modify objects within an Oracle database, like tables, procedures, etc etc. The project is still in its infancy, so it is VERY lacking in features, but it is getting new features every month. The app uses GTKSourceView and a hacked version of GtkSheet as well as the libsqlora dev application that ties this app in with the Oracle libraries.
Win32 version also available for download. Always updating.