The Windows GUI version of SQL*Plus implements an Environment dialog from which you can specify values for many of the options you would otherwise control via the SET command. Two environment options are unique to Windows GUI SQL*Plus. To get to this Environment dialog, run the Windows GUI version of SQL*Plus and select the Options Environment menu option. Youll see the dialog in Figure 14-2.
Figure 14-2. Windows GUI SQL*Plus Environment dialog
The left half of the dialog in Figure 14-2 provides a cumbersome alternative to using the SET command. For example, rather than issue SET LINESIZE 132, you can open this dialog, scroll down in the list of Set Options to linesize, click the Custom radio-button, and type the value 132 into the text box below the On and Off radio buttons . Believe me, you'll find it easier to use the SET command.
The right half of the dialog however, provides two options unique to the Windows GUI version of SQL*Plus. Buffer Length represents the number of lines of scrollback history that SQL*Plus maintains. If you're bringing back large amounts of query results that you'd like to scroll through, you may find it helpful to bump up the Buffer Length to a higher value. At least, I've often used that ability.
Buffer Width represents the left-to-right width of the SQL*Plus window. If you increase LINESIZE above 100, you'll find that Buffer Width is automatically increased to match, so you don't need to worry about manually specifying a value. The only reason to specify a value manually for Buffer Width is if you want to free up memory by reducing it. Probably due to the generous amounts of memory in most modern computers, I've never found memory consumption by the SQL*Plus screen buffer to be anything worth being concerned about.
Introduction to SQL*Plus
A Lightning SQL Tutorial
Generating Reports with SQL*Plus
Creating HTML Reports
Writing SQL*Plus Scripts
Extracting and Loading Data
Exploring Your Database
Tuning and Timing
The Product User Profile
Customizing Your SQL*Plus Environment
Appendix A. SQL*Plus Command Reference
Appendix B. SQL*Plus Format Elements
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Authors: Jonathan Gennick
Similar book on Amazon