I used to to use yasql as a sqlplus replacement, it was pretty basic but much better.

sql-oracle mode in emacs takes away a lot of the pain of using sql-plus (if you're an emacs-er)

gqlplus is pretty good too.

I use sqlpython.