4 ms·
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 quer
by fusiongyro 14y ago
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.
- mercurial 14y agoEven 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-developer/overview/index.html http://www.oracle.com/technetwork/developer-tools/sql-develo...
- mickeyp 14y agoOr if you're an Emacs user you can use sqlplus.el, a very nice wrapper around SQL*Plus.
- fusiongyro 14y agoI 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).