UVM Logo
The
University
of
Vermont

 

SQLPLUS.

Many RDBMS systems have an "interactive" SQL tool. ORACLE's is
"sqlplus". In addition to providing a simple way to execute SQL commands,
SQLPLUS provides many "report" capabilities such as commands to 
create column and page headings and commands to reformat numeric and
date fields. SQLPLUS also supports writing the output to a file rather than to
the screen.


 
 
  • SPOOL 
  • DESCRIBE 
  • COLUMN 
  • PAGESIZE 
  • LINESIZE 
  • SET HEADING OFF 
  • BREAK ON column-name SKIP 1 

 
 
 
 
 
 

 
Copyright 1995 University of Vermont and others. All rights reserved.
 Brought to you through the courtesy of Computing and Information Technology, University of Vermont. Copyright © 1996 The University of Vermont and others. All rights reserved.

The University supports both institutional and personal web pages. The views expressed on personal web pages are strictly those of the author, and are not reviewed or approved by the University of Vermont

Read the Webmaster's Policies.

Send questions and comments to webmaster@uvm.edu

Last page update: March 21, 1997