Oracle, has without a doubt, the worst command-line interface tool ever. That being said, most Oracle engineers don't seem to even use the CLI. They all use GUI tools. Fair enough. But I still like a good CLI like PostgreSQL or MySQL (the CLI is not quite as nice as PostgreSQL, but it's very good).
These are some settings that I found myself always setting in SQL*Plus:
SET SERVEROUTPUT ON SET PAGESIZE 66 SET LINESIZE 80 SET HEAD OFF SET PAGES 50000 SPOOL lpr SPOOL OUT
Every RDBMS has different dumb ways to handle dates.
WHERE doc_date > to_date('04-Dec-2000 10:01 AM', dd-Mon-yyyy hh:mi PM') where doc_date > sysdate-1