Hacker News new | past | comments | ask | show | jobs | submit login

It's worth noting that using some of these features bump you up into a different pricing tier. And last time I checked the usual way to achieve a recursive query was with the non-standard "CONNECT BY" syntax. I have found rlwrap does a lot to mitigate the pain of sqlplus, but I still use it (and Oracle) as little as I can possibly get away with.



Even with rlwrap, sqlplus is awful. However, you can try SQL developer, which is fairly decent GUI frontend:

http://www.oracle.com/technetwork/developer-tools/sql-develo...


I actually wind up using both. But SQL Developer is pretty heavy and I prefer using psql to a GUI tool with Postgres, so I wind up in sqlplus a lot (when dealing with Oracle, which is seldom).


Or if you're an Emacs user you can use sqlplus.el, a very nice wrapper around SQL*Plus.




Consider applying for YC's Summer 2025 batch! Applications are open till May 13

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: