Oracle

From Noah.org
Revision as of 14:20, 2 September 2007 by Root (talk | contribs) (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...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search
SET SERVEROUTPUT ON
SET PAGESIZE 66
SET LINESIZE 80
SET HEAD OFF
SET PAGES 50000
SPOOL lpr
SPOOL OUT

WHERE doc_date > to_date('04-Dec-2000 10:01 AM', dd-Mon-yyyy hh:mi PM')
where doc_date > sysdate-1
Retrieved from "https://www.noah.org/mediawiki-1.34.2/index.php?title=Oracle&oldid=3068"