• Design
  • Tuning
  • Apache Derby
  • IBM DB2
  • MySQL
  • Oracle
  • SQL Server

    • Oracle SQL*Plus

    You are currently using a web browser that does not support HTML pages with style sheets. Please try the XHTML 1 or XHTML 1 Mobile version of this page instead.

    set command

    SQL*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';

    For SQL*Plus scripts

    How to log commands and SQL and their output to a file.

    set echo on spool logfile[.lst] ... spool off

    back to top

    Last updated Thursday April 19, 2007

    Printer-friendly PDF* format:

    Oracle SQL*Plus

    This Section

    You are currently viewing this page in XHTML 2 Style Sheet* format (* see Clicklets for more infomation). This document is also available in HTML Style Sheet*XHTML 1* XML* HTML 4*HTML 5 Style Sheet*HTML 5 XML*HTML 5 non-XML* 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.