Add Site or Add Page to Favorites
>  Computers > Databases > Oracle > SQL*Plus >

 Set Command 
 
DesignTuningApache DerbyIBM DB2MySQLOracleSQL Server
SQL*PlusSet

Preview DRM-free music
Play clips of the most popular DRM-Free music in MP3 format
Legal Music .com

Get information on your favorite TV Shows at TV Series .com

Clarify the meaning of the acronyms on your web site.

Acronym Dictionary

Acronym Finder

Social Networking Web Sites

Register your own domain name at A to Z Domains.

or buy domains at Domain Names For Sale .net

Printer-friendly PDF* format:

Oracle SQL*Plus

This Section

Oracle SQL*Plus

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

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

Copyright © 2006 How To Guides .com. Alteration of content, including addition of any function such as hypertext links or pop-up advertising, or interference with the hypertext links or other functions of this site is expressly prohibited.

DISCLAIMER: All information, links, forms, applications and other items on this site or obtained from it are provided AS IS, WITHOUT WARRANTY OF ANY KIND EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.