set commandSQL*Plus parameters are set with the SQL*Plus set command.
Session parameters are set with an alter session set ... command.
set pagesize 50000
alter session set nls_date_format = 'mm/dd/yyyy hh24:mi:ss'
nls_timestamp_format = 'mm/dd/yyyy hh24:mi:ss.ff6';
How to log commands and SQL and their output to a file.
set echo on
spool logfile[.lst]
...
spool off
Last updated Thursday April 19, 2007
Printer-friendly PDF* format:
You are currently viewing this page in XHTML 1 Style Sheet* format (* see Clicklets for more infomation). This document is also available in XHTML 1*XML*HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* XHTML 2* XHTML Mobile* WML Mobile* and printer-friendly PDF* formats. This is accomplished with Single Source Publishing, a content management system that uses templates in XSLT style sheets provided by XML Styles .com to transform the source content for various content delivery channels. There is also RDF* metadata that describes the content of this document.
