Oracle

From Noah.org
Revision as of 14:46, 2 September 2007 by Root (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

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