Difference between revisions of "Oracle"
From Noah.org
Jump to navigationJump to search (New page: <pre> SET SERVEROUTPUT ON SET PAGESIZE 66 SET LINESIZE 80 SET HEAD OFF SET PAGES 50000 SPOOL lpr SPOOL OUT </pre> <pre> WHERE doc_date > to_date('04-Dec-2000 10:01 AM', dd-Mon-yyyy hh:mi...) |
|||
Line 1: | Line 1: | ||
+ | [[Category:Engineering]] | ||
+ | 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: | ||
<pre> | <pre> | ||
SET SERVEROUTPUT ON | SET SERVEROUTPUT ON | ||
Line 10: | Line 13: | ||
</pre> | </pre> | ||
+ | Every RDBMS has different dumb ways to handle dates. | ||
<pre> | <pre> | ||
WHERE doc_date > to_date('04-Dec-2000 10:01 AM', dd-Mon-yyyy hh:mi PM') | WHERE doc_date > to_date('04-Dec-2000 10:01 AM', dd-Mon-yyyy hh:mi PM') | ||
where doc_date > sysdate-1 | where doc_date > sysdate-1 | ||
</pre> | </pre> |
Latest revision as of 14:46, 2 September 2007
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